Calculation Fields

General support questions.
Posts: 17
Joined: Wed May 11, 2005 3:33 am
PostPosted: Sat Aug 20, 2005 4:17 am
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.
SeedCode Staff
SeedCode Staff
Posts: 2764
Joined: Thu Nov 20, 2003 11:01 am
PostPosted: Sun Aug 21, 2005 6:31 am
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.
John Sindelar
SeedCode

Return to General Support

Who is online

Users browsing this forum: No registered users and 2 guests

cron
(855) SEEDCODE
[email protected]
Follow us: