AnsweredAssumed Answered

Importing info into file with multiple tables

Question asked by bk1 on Mar 27, 2014
Latest reply on Mar 27, 2014 by bk1

Title

Importing info into file with multiple tables

Post

     I have a source file with records containing data which has to be split and imported into three related tables in a second file. The only way I figure to do this is to:

     1- Import the info into the parent table, thus assigning each record a computer generated primary key.

     2- Export the primary key to the source file (using the ID from the source file as a match field).

     3- Import the records into the 2nd & 3rd tables along with the primary key so that they will be related to the parent table.

     Is there a better way?

Outcomes