3 Replies Latest reply on Jan 23, 2015 8:15 AM by philmodjunk

    importing one table into two tables

    weedonpaul

      Title

      importing one table into two tables

      Post

      Hi

      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?