Hello, I have a table like this:
ID SiteID Job Number_request approval 1 100 math teacher 4 2 100 science teacher 3 3 100 english teacher 2 4 101 summer helper 3 5 101 office assistant 1 6 103 office assistant 2 Then I created a form with those info and a checkbox with each siteID. If any checkboxes are checked, a "Yes" value will be assigned to approval field in the table. My problem is, for sites with more than one checkbox (like siteID 100, 101), how can I know which one I ckecked, which one not checked based the on the unique ID? or how can I do it? Thanks Franl ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:341016 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm