I have 3 tables: a Book table, a Category table and a CategoryList table that is a join table for the other 2. It stores book ids and category ids.
I created a recordset to list all the categories and then used a repeat selection around a checkbox to display all the categories with checkboxes next to them.
I have successfully created an insert form that inserts a book as a single insert and on the same page a multiple insert that inserts all the categoryids from the category table into the category list table via the checkboxes on the page (I hope you can understand this)
I also did the manage relational tables for all 3 (I wasn't sure if this was necessary)
This all works perfectly.
I am now trying to do the same with the update page but I am having a problem tying the current data into the check boxes. I have successfully created the update form for the single update of the books. I have created a recordset to list all the categories (as I did on the insert page) But I don't know how to check the checkboxes that are already listed in the database. I guess I need to create another recordset to display all the categorieslist ID's that are associated to that book - but I don't know how to tie these together. Also when I update the form the categoriesList table doesn't update. I suppose I could simply use an insert multiple form for the categoriesList table and force the user to check all the categories again but it would be more professional if I could display the current ones and allow them to add/remove the ones they want.