I'm having a real hard time trying to logically figure this out. Here's what I have: <cfquery name="getprocesses" datasource="#dbname#"> SELECT * FROM Processes, Materials, code_material WHERE code_material.materialid=materials.materialid AND processes.code=code_material.code </cfquery> <cfform action="enter_HMinfo3.cfm"> <cfoutput query="getprocesses" group="code"> <table> <input type="hidden" value="#session.siteid#" name="siteid> <input type="hidden" value="#session.locationid#" name="locationid"> <TR> <TD><input type="checkbox" name="processcode" value="#code#" checked></td> <td colspan="2">#getprocesses.code# #getprocesses.process#</td> </tr> <cfoutput> <TR> <TD> </td> <TD><input type="checkbox" name="materialid" value="#materialid#" checked> <TD>#getprocesses.material#</td> </tr> </cfoutput> </table> </cfoutput> <input type="submit" value="Next ->"> </cfform> On the action page, I want to insert each processcode that is checked, along with the corresponding materialids, with the siteid and locationid into a record. What I'm getting is one record with a long list of values inserted into each field. Any ideas appreciated. I realize there must be a loop function in there somehwere, but logically I'm brain dead this Friday morning. Thanks, Erika Foster engineering-environmental Management Applications Developer (505) 866-1654 [EMAIL PROTECTED] ------------------------------------------------------------------------------ Archives: http://www.mail-archive.com/[email protected]/ To Unsubscribe visit http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
