So we recently purchased the full version of the 2017 Wisconsin Manufacturers Register and with it came a subscription for a website to access the information online. Anyways, importing the information from EZ Select to Filemaker is pretty straight forward, downloaded the file as an Excel spreadsheet and clicked the import button on Filmmaker (if it is of any help at all, we are running FM Starting Point 4.6.7).
The problem comes not when importing the accounts, but the contacts that come with the accounts. Each account is accompanied with 1-10 contacts (Executive 1, Executive 2... etc.). The accounts fields and contact fields are listed under two different tables, and I am stumped about how to approach this situation.
I have very minimal experience with Filemaker, we purchased the software last month and I am only in the office to work on it once or twice a week as school takes up the rest of the time and I appreciate any help that may come my way.