AnsweredAssumed Answered

Auto-generate serial number in related field upon Excel file import

Question asked by JohnFrankson on Mar 7, 2014
Latest reply on Mar 10, 2014 by philmodjunk

Title

Auto-generate serial number in related field upon Excel file import

Post

     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?

Outcomes