Multiple asp pages to update one record in access database

[gmagerr]

Hi guys, i have 4 or so pages that all need to update the same record in one of my tables in an access database. for instance, the first page will get all the user information, the second page will show a company name and have products to select.. same on the next page. etc etc etc. how would i make it so when a user finishes selecting the products he or she wants from one page, and clicks to go to the next page to select more stuff.. the record in the database will be updated. what i'm trying to ask (and i'm not doing a good job) is how can i update one record from multiple pages? how would i go about doing that? Thanks in advance.

 

[lobstah]

depending upon the nature of the data, you could either update the record for each page, adding the data from that page, or you could store the data from page to page, either using session variables or hidden fields in the form, then do one record update at the end of the four pages.

if all data is not required of the user, and the user can exit the process without completing the four pages (and that's allowable in your application) then the first option is probably the best/easiest, but if it's an all or nothing thing with the data, then need to store it all until the end, then do your database update.

there have been some extensive discussions on storing in session variables versus hidden fields in this forum that you should be able to find upon searching.