AnsweredAssumed Answered

Import data into two tables

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


Import data into two tables


     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