What's the best way to add a parent record and child record at the same time. Currently the child links to the parent via the parent's ID/Key field. This value is automatically generated with the auto increment setting within the database.
I need to figure out how to get this value back to add the linked child. I don't want to do a search for the last record in case two users happen to be doing the same function at the same time.
