In the database I am making, I have a table “documents” and a table “categories”. These two are joined to a third–“documentcategories”–by a primary-foreign key relationship.
On the data-entry form, I want to have a series of checkboxes, one for each category. When the user checks one, I want to add a record to the “documentcategories” table, associating the current documentID with that particular categoryID.
My question: Is this possible to do entirely in the form, or do I have to use a macro? Is it possible to do even with a macro? If so, how would I go about it?
Any help on this is appreciated.
-AnthonyP