The basic mechanics are fairly straight forward. You can do two imports of the data, once into your people table and one into your test data table. The trick here is to correctly link the imported records by ID number after you've imported. You don't describe any column in your spreadsheet that uniquely identifies each person. The name column or columns may serve, but you may also have two or more people with the same name--so you'll need to check on that first.
If name is the only identifier available, you'll need to set up this relationship at least temporarily:
People::NameField = TestData::NameField
Make sure that you enable the auto enter options when importing into people so that each new record get's a new name. Also specify unique values for the name and "validate always" so that multiple entries get entered only once in the name table.
You can also use Replace Field Contents to assign serial number ID's to your newly imported records right after you import them. Sometimes, this works better if you have other auto-enter options you don't want activated during import.
Either way, once your people records have ID numbers, you can use Replace field Contents to copy the ID number from the related People Record into each TestData record to link the two. After doing so, you can delete teh name field from the test data table and can revert back to using an ID number based relationship to link your two tables.
Thank you that helps. I do have a unique identifier in the Person table (KP_Id_person) that is an autogenerated serial number everytime a new record is created and connects to (KF_id_person) in the Test table.
So I import all the people first, take the KP_Id_person from the set of newly imported records and add this number as a new column (KP_Id_Person) to the spreadsheet. Then I import the spreadsheet again, but into the Test Table, and match the field "KP_Id_person" in the excel to the "Kf_id_person" in the Test table.
Yes, but you need a unqiue identifier in the Excel spreadsheet to match the imported data up.
Thanks! Worked beautifully.