AnsweredAssumed Answered

Import from a flat table into a FMP file with related tables?

Question asked by flybynight on Mar 12, 2013
Latest reply on Mar 12, 2013 by Lemmtech

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?