[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

[skyhawk133]

Let's do this in reverse, tell us what you are trying to accomplish, and we can most likely assist you in coming up with the code, I can't tell exactly what you want to do, where the values need to be after submission, etc. etc. So if you give us a scenario, I'll let you know the best way to attack it.

[mindytruitt]

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.

That is the main idea I want to accomplish. I hope that helps to describe it.

Thanks

[skyhawk133]

You can do 1 of 2 things... I prefer using the onclick/onchange(submit) method... when a drop down menu or form is filled out, it submits the form to itself and then populates the drop downs based on the values selected, the other option is to create a fairly elaborate javascript that will slowly eliminate choices as other choices are selected.

You should be able to put all the fields in 1 form, and then check if each field is defined, if it is, you can then populate the corresponding drop down menu based on the value using a query. Then when all the fields come in you can insert/update/delete accordingly.

[mindytruitt]

Works Great

Thanks a Ton,
Mindy

[shiroh]

I know you found a solution to this already but you can also check out the custom tags TWOSELECTSRELATED and THREESELECTSRELATED (I'm not sure where to find them anymore but you can search the developers exchange on Macromedia.com for them). This solution would only work if your drop downs are in a database and the tables are somehow related so you can produce a query with the relevant information for populating the select lists. These tags are pretty useful if you don't want to have the screen refresh every time a user selects an option.