5 Replies Latest reply on Feb 12, 2013 11:41 AM by philmodjunk

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

    pbedouk

      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