multiple row insert, selected rows
I have a product table whose items can belong to one or more categories.
When adding a new item to my products table, i want to be able to associate the new item with multiple categories
I have used the datassist wizard to insert multiple rows from text fields, how can i use my category recordset to do something similar, using the recordset rows to populate the form, then inserting all rows whose checkbox is ticked ?