Importing related records
As my users have Filemaker Pro clients on their not networked notebooks, I often have to import data from their locally stored files into the main file of my solution.
The problem is, that the records that need to be imported come from different tables and come with a whole bunch of relations. When importing the records "as they are" and allowing Filemaker to create new serial numbers the relations don't work anymore, as the relationships are based on the serial numbers on the client machines.
My question: How can I import all these new records from different tables including working relationships?
Thank you in advance,