AnsweredAssumed Answered

How to import records into the related table of a one to many relationship?

Question asked by pbedouk on Feb 8, 2013
Latest reply on Feb 12, 2013 by philmodjunk

Title

How to import records into the related table of a one to many relationship?

Post

     Hi

     I am wondering how to import records (from excel) into the table on the many side of a one to many relationship?

     I have a Company table and a People (who work at the company) table set as a one to many relationship in the relationship graph.  the many side has "allow records to be created ..." checked.

     I have 2 excel spreadsheets, one containing company name and other stuff, and the other containing a row for each person, including their company name. I thought I could use the company name as the matching field between the 2 tables.

     Importing the Company info works fine.   When I go to import the People info , all the tables in the Target field of the Import dialog are greyed out.  The People table shows up in the related table area, but not selectable.

     How do I do it?

     Thanks

     Peter,  FM12PAd, OSX 10.8.2

Outcomes