Importing data into related fields

[VirtualBob]

I have a file called People that contains Name & Phone number fields

 

Then a related file called Addresses that contains address fields, which appear as related fields in the People file Addresses::Suburb etc

 

How do I import both the names and addresses from a single external file?

 

If I try to import into People file it doesn't display the related Address fields in the import dialog

 

If I try to import into Addresses file it doesn't show the People ID (as its related) in the import dialog that I need to match the address records to

 

Or am I missing something obvious in this process?

[Matthew F]

I don't think that you can import data into related records.  That could get complicated depending on how your relationships are structured.  This would only work if you have 1:1 relationships between People and Addresses (in which case you wouldn't need two tables to begin with).

 

If you're doing the import with a script then you would want to go to a layout for people and import data here first, then go to a layout for addresses and import the corresponding data here.  It might be easiest if you create a custom import layout for each table that includes only the fields that you want to import.