Hello, I'm creating data entry and update forms. When a user adds a new record to the form a primary autonumber value is created in the date_id field for that record. How do I retrieve this value after inserting the new data so that I can insert data using that primary key as a foreign key in other tables?
Thanks,
S./