Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 1 of 1
Thread: Insert Data into two tables
02-12-2012, 02:41 PM #1
- Join Date
- Feb 2012
- Thanked 0 Times in 0 Posts
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