Can someone help me? I have a flat data base that has about 20,000 records in FM 8.5 advance. The problem is that it was not set up right so one client maybe in the database multiple times. I am designing a new database in FM 11 Pro to have a one to many relationship. One Client to Many animals . I need to transfer the information into the new database and assign each client an ID number. For example: Sue Smith has 25 records in the 1st database. I want to import Sue Smith into the new database (client table) and give her an ID number and only have one record for her in the client table. Then I also need to assign an ID number to each animal that Sue Smith owns and add them to the animal table.

Thanks!

In a working copy of the database, create the ID number (key). You will do two imports. Do one import for the fields of information in the client table after doing a find to get only one of each record.

Then import the records for all records to the animal table. The only common field in the imports is the ID Number field.