Importing into related tables
I have developed a FM relational database with 4 related tables. I am importing information into each table from a flat FM file with over 3000 records. The foriegn key filed in my Child table is setup as a pop up menu that displays the Primary Key info from the parent so when i select the matching record it brings in all the info from the parent into the child table.
My question is how can i set this up so it does it on import? All other information imports correctly into each table, but as it is now, in the child table i must select the info in the drop down to bring in the info from the parent on every record. With 3000 records that could take a while.