Learning as I go… building a new solution and trying to build things the "right" way. So as part of this solution, I have a "Companies" table with info specific to the company: __pk_CompanyID, CompanyName, BillingAddress, etc. Then I have a "Contacts" table with info specific to the contact: __pk_ContactID, _fk_CompanyID, the contact's specific contact info, etc...
But, there are legacy files all over the place that we want to import. Some stuff in QuickBooks that we can export, some salesmen have their own list of contacts, usually in an Excel file.
Is there an elegant way to import these into FileMaker, preserving the relationships between Companies and Contacts?
Or would you have to put in all the ID fields and then do 2 imports?