importing one table into two tables
I have a table in fm11 that has 12000 people (address, contact and company) I am in the process of creating a new database in fm13 in which I will import all my records. many of the contacts have the same company and therefor I would like to create two tables one for the contact and one for the company. when I import all the records I will only import the fields that go with the contact to go to the contacts table and the fields that go with the company to go to the company table. how do I do this so that I don't create multiple records for the same company and so I link each contact to the correct company?