Forums
This topic is locked
Add Records / Navigate Recordset in one form
Posted 01 Sep 2006 23:33:34
1
has voted
01 Sep 2006 23:33:34 Jerry S Graham posted:
I'm using Dreamweaver MX.My server is SQL2000. I'm using ASP and VBScript.
I have a table sctructure that relates multiple child records to one master record. Once my user has created the master record I want to put them into a cycle of entering the child records (much like creating an Access form with a subform - but, of course, using html forms). I need to allow them to page back and forth between the records as they enter data until they have entered all the child records. I would like to keep them in the same form with 'forward' and 'backward' buttons that appear when/if there is a previous or next record. They may also have to delete one of the child records before they complete the cycle.
It seems like I have to create some kind of Session variable that increments/decrements as the user adds new records or pages back to a previous record until they exit the loop. This Session variable will become the key to each record as the user navigates.
So the visual structure would look like this:
MASTER RECORD 1
CHILD 1
CHILD 2
CHILD 3
CHILD 4
ETC... (for as many as they need)
How do I create multiple 'optional' actions for the same form on one page? Is there a better way to do this?
There may also be multiple users in their unique sessions, but the master record id will always be unique.