Insert Data into two tables
I am using ASP and would like to insert data from a form into an access table. Once this is inserted it is given an ID number. Once added after insert I would like that ID number added into another access table.
Is this possible as I have tried several ways with no success? I can insert the data ok but can't think how to update the other table with the new data. Do I do it with script or create something in the access table to auto update the other table?
Any suggestions/help will be greatly appreciated