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!
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!