AnsweredAssumed Answered

importing one table into two tables

Question asked by weedonpaul on Jan 23, 2015
Latest reply on Jan 23, 2015 by philmodjunk

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?

 

Outcomes