Making a list of checkboxes based on a reference table

K

Kevin

Hi,

I have a situation where a product can be in 1:M categories and I've
modelled it with 3 tables:

Product table (productID, etc)
CategoryRef table (categoryID, categoryDesc)
ProductCategoryLink table (product ID, categoryID)

Can someone suggest how I go about creating a scrolling list of check
boxes showing all the possible categories from the CategoryRef table
but stores the selected entries in the ProductCategoryLink table?

I know a mulit-select listbox can do it but I'm looking for something
to have checks. I've started down the road of a subform of checkboxes,
trying to dynamically create check boxes, but I don't know what is the
most effective way in Access.

Any suggestions/links/samples would be greatly appreciated,

Regards,
Kevin
 
Top