Software: Dreamweaver MX 2004
Project: ASP,VBScript, local testing server Win XP Pro.
My experience: This is my first dynamic web site, went thru couple books and video tutorial’s about ASP.

Little bit about what I am trying to do:
I want o build a registration page for customers. In the registration page person enters his or hers info. Lover in the form from the dropdown menus they select “material status” and from another drop down menu they choose how many “children” thy have. (All this is on one form, I have all needed record sets created, and options from the dropdown menu also are pulled from database)

This is what I am trying to accomplish:
If the person chooses ‘married’ from the “material status” dropdown menu, and he or she has ‘3’ children selected in “Children” drop down menu, after clicking “Next” button at the bottom of the form, I want server generate page with forms for “spouse” and thee forms for “Child #1”, “Child #2”, “Child #3”.
In the simpler words, if the customer in first page chooses ‘Material status’ – “Single”, ‘Children’ – “0”. After clinking next customer will be taken to the page with 4 ‘Children’ forms and no ‘Spouse’ form.

My questions:
How do I connect (tell server) , witch forms to display in next page, and how many times to repeat ‘Children’ form based on the options selected in previous page, from drop down menu’s? Can this be done thru Dreamweaver menus, or it has to be hand coded? Is there Extensions available to help me accomplish this task?
Here is website link, I want to build something similar in ASP: http://www.greencardlotterygroup.com/cgi-bin/main.pl

Please help me. I will appreciate any suggestions, links, suggested books and tutorials.
Thanks a lot.

gint,

try posting this question to the ASP SQL forum on this site and see what kind of response you get. I would try to help you, but my ASP is rusty as I usually use PHP to accomplish something like this.

Kaiman

Website Design, Hosting, and Promotion - Glenwood Springs, CO
Computer Repair, Networking, Training - Glenwood Springs, CO

Post it ina asp column and you would get faster reply

If I were you, I would do this in PHP. I'm not an expert, but i could do something like this. I don't currently know how to make the drop down boxes but that can't be that hard.

I could make a form to submit this kind of thing, but i wouldn't be able to get it onto a database, i've never used SQL properly myself.

If you wanted to make a separate page for each person who submitted, I could give you the script.

I doubt something like this could be done just using the built in dreamweaver things - you'd have to do at least some hand coding.
First of all, think about databse design. I'd have 2 tables - one for the details of the person filling out the form, and one for the childrens details.
Table: Person
PersonID, Name, NumberOfKids, MaritalStatus, SpouseName
Table: Children
ChildID, ParentID, Name

Psudo Code:
- Display form to ask user for Name, Marital Status and number of children.
- Insert data into table 'Person' and return the PersonID
- If MaritalStatus is Married
--- Redirect to page to ask spouses details
--- Update Person table with spouse details, based on PersonID returned earlier to reference the right record
- If more than 0 children, redirect to page to ask about childrens details
- Input childrens details, insert into database, setting ParentID to PersonID returned earlier
- Count records in table 'Children' where ParentID = PersonID returned earlier
- If this number is lower than the number of children, refresh the page and ask for another one. Otherwise, end.

Another way would be to dynamicly generate a form containing the correct number of input fields, and a hidden field containing the number of kids. Then when the form is submitted use a for..next statement to iterate through each set of fields and build an INSERT Statement into each one.