Dear Gents,
I have a continuous form that have some items , Every item have check box beside it and linked with field in the table.
I have a combo box which have all colors for this item and button to submit the change by this sqlstatment "Update items set color = "Green" while checked = -1" , I need to insert in the log table when i change bulk of items using the check box to be link
Item 1 has been changed to green
item 2 has been changed to green
item 3 has been changed to green
item 4 has been changed to green
And so on based on how many items i have checked.