calculated field via realtionship 
Author Message
 calculated field via realtionship

This calculation of a field to equal another via a relationship is driving
me crazy.

1.  If I can drag a related field into a layout can I assume the
relationship is a valid one?

2.  If so, under what circumstances might I be unable to create a
calculation field of the same type (text in this case)?  I get a field not
found error.

3. I have trashed preferences, allocated more memory, rebooted with
extensions both on and off, tried to 'recover' (no files show up), all to
no avail.

4. I have deleted and recreated the relationship and it works fine
displaying the related field.   I just can't a calculation so that the
content equals that field.

Has anyone run into this before?

Any suggestions?

Could a desktop rebuild be a factor?  I'm going to try that too as soon as
I send this off.

--
Harvey Waxman
Harvey Products
Makers of DinghyDogs?
http://www.***.com/

Feeling Tipsy?
Keep On The Level



Sun, 24 Aug 2003 09:57:05 GMT
 calculated field via realtionship

MacOS8.6  FMPro 5.0

Update:

Rebuild of desktop did nothing.

There are several fields in the related file that can't be used in a
calculated field.  For instance, the address can't but the city can.

I tried creating a calculation field in the file itself equal to the fields
in question and they "aren't found" either.

It appears that this file is corrupt yet it doesn't appear in the 'recover'
option list.

Is there a way you would recommend to fix this without remaking the file
and its relationships and scripts and retyping in all the data?

Thanks for any insight.


Quote:

> This calculation of a field to equal another via a relationship is driving
> me crazy.

> 1.  If I can drag a related field into a layout can I assume the
> relationship is a valid one?

> 2.  If so, under what circumstances might I be unable to create a
> calculation field of the same type (text in this case)?  I get a field not
> found error.

> 3. I have trashed preferences, allocated more memory, rebooted with
> extensions both on and off, tried to 'recover' (no files show up), all to
> no avail.

> 4. I have deleted and recreated the relationship and it works fine
> displaying the related field.   I just can't a calculation so that the
> content equals that field.

> Has anyone run into this before?

> Any suggestions?

> Could a desktop rebuild be a factor?  I'm going to try that too as soon as
> I send this off.

--
Harvey Waxman
Harvey Products
Makers of DinghyDogs?
http://www.dinghydogs.com

Feeling Tipsy?
Keep On The Level



Sun, 24 Aug 2003 10:38:32 GMT
 calculated field via realtionship
Harvey,

Are you saying you want, in File A, to define a calculation field as:

Relationship::Field

?

I'm not following what you mean by 'drag a related field into a layout'. If,
for example, you copy a whole layout that has some related fields on it, and
paste "it" into another (blank) layout, and then go to File B and delete
some of the related fields that were on the layout, and then go back to the
pasted "layout", graphical representations of the deleted fields will still
be present, with 'field missing' where the field name oughtta be. If you
double click on the "fields", you will get the usual dialog box for
identifying the field, but, if you fail to so identify a field, and close
the dialog box, the "field" will disappear from the layout.

I keep using double quotes here because layouts do not really contain the
fields; they only contain graphical references to them. Thus, when you copy
and paste a "layout", you are really only copying and pasting its graphics,
and the graphics can remain, for a while, without the existence of the
fields they claim to represent.

If, in the define fields box, the field you want does not show up in the
related fields list, then it ain't there. If it is in the list, just double
click on it and make it the sole argument for your calculation, although
there is almost no difference between doing that and simply placing the
(related) field on the layout. But I very strongly doubt that all that
re-jiggering was necessary.

--

John Weinshel
Datagrace
Associate Member, Filemaker Solutions Alliance
Vashon Island, WA
(206) 463-1634


Quote:
> This calculation of a field to equal another via a relationship is driving
> me crazy.

> 1.  If I can drag a related field into a layout can I assume the
> relationship is a valid one?

> 2.  If so, under what circumstances might I be unable to create a
> calculation field of the same type (text in this case)?  I get a field not
> found error.

> 3. I have trashed preferences, allocated more memory, rebooted with
> extensions both on and off, tried to 'recover' (no files show up), all to
> no avail.

> 4. I have deleted and recreated the relationship and it works fine
> displaying the related field.   I just can't a calculation so that the
> content equals that field.

> Has anyone run into this before?

> Any suggestions?

> Could a desktop rebuild be a factor?  I'm going to try that too as soon as
> I send this off.

> --
> Harvey Waxman
> Harvey Products
> Makers of DinghyDogs?
> http://www.dinghydogs.com

> Feeling Tipsy?
> Keep On The Level



Sun, 24 Aug 2003 10:52:49 GMT
 calculated field via realtionship
Sorry if I confused you.  By 'dragging a related field I should have said
dragging the field icon from the toolbox, selecting the relationship and
then the appropriate field.

But I solved the problem.  It appears that some fields were damaged.  The
files behaved normally in every way - every script worked and every
relationship worked.  It was only when I tried to create a calculated field
equal to certain fields in this one file that I was unable to do so.

I created a copy of the file, deleted the offending field, re-created a new
field and imported the data from the copy to that field only.  Now I can
created the calculated field as I expect to.

What a crazy experience.  I would never have found the damage if I hadn't
tried to make the calculations.  I thought I was doing somethin wrong.

Thanks again

Harvey


Quote:

> Harvey,

> Are you saying you want, in File A, to define a calculation field as:

> Relationship::Field

> ?

> I'm not following what you mean by 'drag a related field into a layout'.

snip

--
Harvey Waxman
Harvey Products
Makers of DinghyDogs?
http://www.dinghydogs.com

Feeling Tipsy?
Keep On The Level



Sun, 24 Aug 2003 11:33:39 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. calculated field based on another calculated field

2. formatting a calculated field via SQL

3. Calculated fields and display via web plugin

4. Storing calculated fields vs calculating on the go

5. How to re-calculate a calculated field

6. Calculating calculated fields in 1 query

7. Help - Calculating With a Calculated Field

8. Calculated fields that don't calculate

9. Calculating with calculated fields

10. Calculated field not calculating?

11. Calculated field based on result of a field

12. Calculate Fields and stuff result in other field???


 
Powered by phpBB® Forum Software