Importing info into file with multiple tables
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?