autofilling/calculating field contents from one of four possible related tables
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.