| | |
| |
Active Server Pages help tutorial how to ASP Help ASP Tutorials ASP Programming ASP Code - ASP Free CJWSoft ASPProtect ASPBanner ASPClassifieds
(Advanced)
(Components)
(Database)
(General)
(Vbscript)
|
|
|
|
Subject: |
Inserting to related tables, on different pages |
|
From: |
Steve |
|
Date: |
3/20/1999 10:30:48 PM |
|
IP: |
208.20.34.147 |
Hi,
I'm planning an app where the Access database will have 4 tables, 3 tables related to 1 parent table through a recordID.
When a vistor adds a records, I want to present the input fields for the parent table first, then post the data (to create the recordID number), then retrieve that number, and go to the next page, which will contain input fields for the next table, and use the recordID number that I just retrieved from the previous insert operation. This way all the tables will relate properly.
I guess my question is (after all this rambling)
1. does this seem like it will work?
2. do i need to save the recordID in a session object, or will passing it as a hidden value from page to page be enough.
3. if I can grab the recordID value from my new record i just posted, can i also grab values such as username, and location?
Thank for any help. |
Follow Up - Re: Inserting to related tables, on different pages - Harlan 3/22/1999 8:52:12 AM
|
|
|
|
|
|
