hello,
i have a web form that is inserting data from its fields to multiple into an access database. the fields belong to multiple tables within the database which is a problem, as i am using dreamweaver cs4. i have successfully done this however the problem is the foreign keys are not entered / set between the different tables. i have decided to pull the primary key by using the SELECT @@Identity for MS access.
Could someone help me with the coding to create and store the session and in the next pages retrieve the session from the previous pages?
the table name=Customer
Autonumber PK= customerID
