How to import records into the related table of a one to many relationship?
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?
Peter, FM12PAd, OSX 10.8.2