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. (The form) ID SiteID Job Number_request approval 1 100 math teacher 4 checkbox 2 100 science teacher 3 checkbox 3 100 english teacher 2 checkbox 4 101 summer helper 3 checkbox 5 101 office assistant 1 checkbox 6 103 office assistant 2 checkbox 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 checkboxes (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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:341017 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
