AnsweredAssumed Answered

Import data into two tables

Question asked by siamack on Jul 31, 2014
Latest reply on Aug 1, 2014 by FentonJones

Title

Import data into two tables

Post

     Newbie here!

     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?

     Thank you

Outcomes