AnsweredAssumed Answered

autofilling/calculating field contents from one of four possible related tables

Question asked by mchancevet@gmail.com on Jan 7, 2015
Latest reply on Jan 11, 2015 by philmodjunk

Title

autofilling/calculating field contents from one of four possible related tables

Post

Hi

I have a 'collation' table occurrence related to 4 other TOs (accom, lab, boat, vehicle).

1 record in collation is a replicate of one of the records from one of the other tables and needs to be related to that record so changes in any record in any of the four tables are reflected (updated) in the collation table.

The relationship is a fID=ID (eg collation::fID=accom::ID) for each of the instances.

I have fields (name, start date, end date, label, category) in each of the four related tables and in the collation table.

For any record in collation I need the above fields to update if the related record in the other table (whichever one of the four) changes.

My difficulty is in defining the calculation for the collation fields since one field in this table needs to update from a field in any one of four other tables.

Thanks

Morgan

Outcomes