2 Replies Latest reply on Mar 27, 2014 9:44 AM by bk1

    Importing info into file with multiple tables

    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?