mak2204
09-25-2006, 01:22 PM
I am working in ASP and Access database.
I have a page with a form, inside the form there is a SELECT statement that pulls all relevent 'yes/no' columns from all relevent tables in the db and makes them checkboxes inside the form.
Now when i check or uncheck these boxes and submit them i need to have the db updated with all the relevent changes in all the various tables.
How can this be done? maybe there is a "FOR EACH CHECKBOX.." statement that can be used?
Any help would be appreciated.
Thanks, Mak.
I have a page with a form, inside the form there is a SELECT statement that pulls all relevent 'yes/no' columns from all relevent tables in the db and makes them checkboxes inside the form.
Now when i check or uncheck these boxes and submit them i need to have the db updated with all the relevent changes in all the various tables.
How can this be done? maybe there is a "FOR EACH CHECKBOX.." statement that can be used?
Any help would be appreciated.
Thanks, Mak.