Switch layouts to a layout based on People before selecting Import Records from the File menu.
I had done that too, and successfully imported the records, but I was hoping Filemaker would manage to populate the foreign keys. It didn't/wouldn't/couldn't ??
So I wrote my first ever looping script to populate the key field. That worked! The script is attached in case other newbies want to puruse.
With the right options and relationships, you can probably avoid needing the above script.
And you may want to check out this script step as a simpler way to loop through a found set:
Go to Record/Request/Page [next ; exit after last]
Thanks for the tip! That definitely simplifies the script.
Here's the new improved script:
I suggest adding an extra Tutorial: What are Table Occurrences? of People so you can set up a relationship that matches by company name. Either a script or an auto-enter field option can use that added relationship to look up data from the people table.
You can also use a script to perform a find for a record in People instead of looping through the records. This will make for a script that is much faster than one that loops through them all.
See this thread for examples of scripted finds: Scripted Find Examples