I'm not sure what you mean, do you just want to pass the Item ID of an item with a radio input next to it? If so just do something like this.
<input type="Radio" name="ItemID" value="#ItemID#"> #ItemName# Then the value of FORM.Item on the next page will be your itemID. ______________________ steve oliver cresco technologies, inc. http://www.crescotech.com -----Original Message----- From: Schwartz, Paul [mailto:[EMAIL PROTECTED]] Sent: Monday, January 21, 2002 2:44 PM To: CF-Talk Subject: Query output in a form question Hello, I have a db table that im querying into an html form table. I would like have an input field linked to each entry in the database. So that on submit it will only show the choices that were checked with a radio button or something. Is this possible? Here is the information that Im wanting to carry over to the second form page. Where the number of items in the database is about 25 items. So that if they only click on the radio button for say item 21 on the second page it will pull all of the inputs from the top table and only item number 21 from the second table. Thanks in Advance. Paul Schwartz <!---code---> <form name="form1" method="post" action="FORM2.cfm"> <table><tr><td> <tr> <td>Name:</td><td><input type="text" name="name"></td> <td>Manager:</td><td><input type="text" name="manager"></td> </tr> <tr> <td>Employee ID:</td><td><input type="text" name="empid"></td> <td>Department:</td><td><input type="text" name="dept"></td> </tr> <tr> <td>Phone Number:</td><td><input type="text" name="phone"></td> <td>Location:</td><td><input type="text" name="location"></td> </tr> <tr> <td>Extension:</td><td><input type="text" name="extension"></td> </TR> <table align=center> <TR> <TD>ITEM1</TD> <TD>ITEM2</TD> <TD>ITEM3</TD> <TD>ITEM4</TD> <TD>KEY</TD></TR> <CFOUTPUT query="ITEMS"><tr> <td width="45%">#ENTRY1#</a></td> <td>#ENTRY2#</td> <td>#ENTRY3#</td> <td>#ENTRY4#</td> <td><input type="RADIO" name="#key#"></td></tr> </CFOUTPUT> <!---code ends---> IMPORTANT NOTICE: This message is intended only for the use of the individual or entity to which it is addressed and may contain information that is privileged, confidential and exempt from disclosure under applicable law. If you have received this message in error, you are hereby notified that we do not consent to any reading, dissemination, distribution or copying of this message. If you have received this communication in error, please notify the sender immediately and destroy the transmitted information. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists ______________________________________________________________________ Get Your Own Dedicated Windows 2000 Server PIII 800 / 256 MB RAM / 40 GB HD / 20 GB MO/XFER Instant Activation � $99/Month � Free Setup http://www.pennyhost.com/redirect.cfm?adcode=coldfusionb FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

