Importing from Excel
I have an Excel spreadsheet with data such as Company Name, Address, City, State, Zip, Phone, web site etc. In the same spreadsheet, I may have many contacts i.e. last name, first name, title, e-mail, phone, etc. that are employed at the same Company. Obviously, there could be a lot of duplicate information as relates the Company data.
My FileMaker Solution has an Account tab and also a Contact tab which relates to the Account. There can be many Contacts for the same Account. How can I do an import to the FM solution so the Contacts are properly imported to the Accounts they belong with?
Below are screenshots on how the Account and Contact tabs appear: