SeedCode Support Forum

Hi All,

I am using FileMaker Pro and Windows 2000. I am having two tables X and Y. Both are related tables. X table has 5 to 6 calculation fields. I want to get the values of some calculation fields from X table to Y table. I am not able to access the values of calculation fields from Y table. X tables' calculation fields are dynamic fields which can't be stored (Storage Option->Donot store results, recalculate when needed). Is there anyway can i get the calculation field values to Y table.

Please give me a solution.

Bye.

You can get access to related unstored fields the same way you do stored fields: assuming there is a relationship between x and y that doesn't use one of the calc fields in questions you can

a) place the related fields from x right on a layout in y;

b) create calculated fields in y that simply refer to the calculated field in x;

c) lookup the values from x into field in y using auto enter calcs like "b" or using lookups.

HTH.