New Record Return for update

Message Topic Search Topic Options Post Reply Create New Topic Printable Version Translate Topic

   Hello,

I've set up a form for users to add records to a DB. Adding new records is a multiple step process where I have users insert general information first, then the users would add more information (to a different table) in another form. How do I have the DB return the record for the general information that was just entered. Since it would be a new number that is generated from the primary key?

All of the examples I have seen for people to update, lists every record available in the DB. That can get kinda cumbersome for the user to have to search for a record they have just entered. Any assistance would be greatly appreciated. Thanks, Jeremy