Checkbox Matrix based on tables - How?

K

kyle.gatewood

I'd appreciate any help someone could give me on this.

I have 3 Tables -

one is a product definition table, it contains
Product_ID, Product_Description

Another is a usage definition table, it contains
Usage_ID, Usage Definition

last I have a Person_Product_Usage table, it contains
Person_ID,Product_ID,Usage_ID

for each person record form, I want a matrix of check boxes, usage
down the left, product across the top, and the check box checked if
there is an entry in the person_product_usage table, that corresponds
to that usage and product. Since my data is not based on one field
corresponding to one yes/no box, I don't know where to begin.

Any suggestions? Thanks!
 
Top