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, 200817 yr by Guest

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

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

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.