Auto-generate serial number in related field upon Excel file import
Hi. I'm having some trouble with relational fields. I have a table with basic info (auto-generated ID number, first name, last name, DOB) and a second table that has other additional info related via the ID number. I'm trying to import new records from an Excel file into the second table and have it also create new records in the first table (more specifically to create that auto-generated ID number). I've got the tables connected via the ID number and clicked the "allow creation..." In the relationship dialog box.
I'm running 13 on a Mac. Any ideas? Is this even possible?