Subform not connecting to main form correctly

[lacey]

Hi,

I have a form based on tblContact with a subform based on table tblCategories, and another subform based on tblCompany. I have a one-to-many relationship between tblCategories and tblCompany, with the pk in tblCategory linking with a fk in tblCompany. All of the fields in tblCategories/sbfrmCategories are yes/no fields, not sure if that plays into my problem at all.

When a user checks one or more of the check boxes in the categories subform, closes the form and re-opens it, none of the check boxes are checked for that person. I know this has something to do with the relationships and how the categories are linked to the contact... but I can't get it straight in my mind as to how that should be set up.

Here is my database. Help and advice for next steps is appreciated! View attachment Contacts Example.accdb

 

[Geotch]

Lacey, your category table doesn't have any way to link to the contact table. I think your Category table needs to capture the contact ID. Then you need to link the master and child forms with the contact ID from each table.