Use Caculation field for relationship

[d1132]

I have a big problem and the most headache heading is the retional relationship.

I want to use a gobal field with value "1" and link it to another table with a caculation field.

I want to show all the record with value "1" in the foreign table. It is that simple.

It suck as filemaker doesn't allow this simple things as the field is a caculation field and can not be stored.

Anyone can solve this prolbem, it consume me more than 30 hours.

Edited July 24, 2008 by Guest

[comment]

It would be helpful to know what is being calculated and why it cannot be stored. IOW, open up the hood. :

[Søren Dyhr]

Ha ha, what are your guesses here Comment, filling a portal with overdues??

It suck as filemaker doesn't allow this simple things

No it sucks that the tool is approached overwhelmingly as a spreadsheet, not even considering the fault might sit some 18" away from the screen.

--sd

Untitled.zip

[IdealData]

The calculation field must be stored in order to be able to generate an index, otherwise the relationship won't work.

Calculations cannot be stored if they reference a related field or global field.