Import data into two tables
I have a simple database with two tables (members and trees) that are joined by primary key & foreign key. I need to import a file of members, each having from 1 to 5 trees. I can import data into one of the tables but not both.
How do I make sure the trees are connected to the right members. FM can generate a unique primary key automatically. How do i get the foreign key to match the primary key?