I have a table that holds a list of products and services offered. What I need is a form that will dynamically produce a list of checkboxes that will update another table with their values of being selected or not. Is this possible? The purpose of the database is to help speed up costing for clients. This started out as something small and has ballooned into something way out of proportion.
I also need a query to be built based on the tblProducts; for every new client input into the system, I would like to automatically insert a value for the product for the client. IE when i put their name in the system the table that holds the selected values of products will automatically make new rows for that client that match up with the product. Can this be done?
Thanks for you help!
I also need a query to be built based on the tblProducts; for every new client input into the system, I would like to automatically insert a value for the product for the client. IE when i put their name in the system the table that holds the selected values of products will automatically make new rows for that client that match up with the product. Can this be done?
Thanks for you help!