AnsweredAssumed Answered

Importing into two related tables from Excel to Filemaker

Question asked by iwrc on Mar 2, 2011
Latest reply on Mar 2, 2011 by iwrc


Importing into two related tables from Excel to Filemaker


Hello always helpful Filemaker geniuses! I need your help again...

I have a table of people that has a one-to-many relationship with a table of test incidences. There is only one possible test they can take (like for reference, imagine you are a company that administers ONLY the basic SAT), but they can take it multiple times.

I have an old Excel spreadsheet of people who took the test on various dates. I want to both import these people's names, addresses, and emails into the "People" table as new records (I have checked to make sure none are already in there), and also import their test dates and scores as new records in the related table of test incidences. Is there a way to do this easily? If I assign each new person entry with a unique People ID number (the primary key on the People table that relates to a foreign key on the Test Table), will it automatically transfer all their personal information while I import to the Test table?

Thank you for your help!