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