In a setup is 1 'master' table and 3 related tables (external files)
where new records may be added trough the relation; the key is the same
for all 4 tables.

To force that a specific related record exists before working on it, the
value of the key is always written to the key in the related table,
after the master is found.

Sometimes new records show up in one of the other related tables, while
they have not been involved in the process.

This situation is not to reproduce.


Is this generating of new records possible according to Filemakers rules?