How To Create A CheckList

M

Martin

15 Customers buy from a list of 35 products. I would like to build a form
which would be a check list to show if my company is the primary supplier of
each product to each customer. The customer would be selected in the main
form and the subform would list all the products with a checkbox and I would
check those products where I am the prime supplier to that customer.
Simplified, my tables look like:
TblCustomer
CustomerID

TblProduct
ProductID

TblPrimeSupplier
PrimeSupplierID
CustomerID
ProductID
PrimeSupplier (Yes/No)

I need suggestions on how to set this up where all 35 products appear in the
checklist.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top