Nesting Forms Problem

[mindytruitt]

I am not even sure it is possible, but I wanted to see if I could nest forms. Both forms work indivdually but when put together I can't get them to work. Any help??

<form name="contact" method="post" action="VCEntryVerify.cfm">
<input type="text" name="PurchaseDate">

<FORM NAME="categoryform" METHOD="POST" ACTION="">

<SELECT NAME="Customer" onChange="change_Contact_menu(this.selectedIndex); ">
<OPTION VALUE="null" selected>Customer</OPTION>
<OPTION VALUE="null">---------------------------------</OPTION>
<CFOUTPUT QUERY="Customer">
<option value="#CustomerID#">#Customer#</option>
</CFOUTPUT>
</SELECT>

<SELECT NAME="Contact_select" >
<OPTION VALUE="null" selected>Contact
<OPTION VALUE="null">---------------------------------
<OPTION VALUE="null">
<OPTION VALUE="null">
<OPTION VALUE="null">
</SELECT>

</FORM>

<input type="hidden" name="Email">
<input type="submit" value="submit">
</form>

Another question, is it possible to have the values that were selected in the drop down boxes (in the inner form) to be an input in the outer form?

Thanks,
Mindy

[mindytruitt]

Overall I am tring to develop a form that submits and sends the info to a database. I am also wanting to have drop down boxes that change on click. The selected values in the drop down box should be sent to the database.

[filipino]

your working on colfusion right what database are you using? you can create a drop down menu on you form by creating a drop down menu on database.

[mindytruitt]

I have two seprate databases pulling the info for the drop downs, but it can be easily changed back into one table. That was just the only way I could get it to work.

VCContact
- CustomerID (Auto Number)
- CusID (Number)
- Customer (Text)

VCContact2
- ContactID (Auto Number)
- CusID (Number)
- SectionID (Number)
- Contact (Text)
- Email (Text)

I have a different table that the form submits to.

VCOrders
- ID (Auto number)
- Customer (Text)
- Contact (Text)
- Email (Text)
- Make (Text)
- Model (Text)
- Serial (Number)
- SalesRep (Number)
- Contract (Text)
- PurchaseDate (Date)
- ExpirationDate (Date)
- Comments (Text)

Would the 2nd drop down change when the first is selected??

Thanks

[Whir]

It's been a long time since I've touched ColdFusion, but I think you can create an event that updates the second drop-down when an option is selected in the first.

If ColdFusion won't do it, you could probably write a simple javascript to do it.

[mindytruitt]

I am using a form in Javascript for the drop downs which works great but my problem is that the drop downs are going inside another form that submits to a database and because of the nested or multilevel forms, it doesn't work. Do you know any other way?

[mindytruitt]

I got it!

Thanks for all the Help
Mindy