Sort fields with checkboxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I developed a data base for all my vendors. There are many fields where I check a box if the vendor has that particular type of product. I can't figure out how to sort by the checked boxes. When I open query design and leave checked only one or two boxes in the hopes of generating a list of only the vendors who carry that product, it does not work.
 
You have a fundamental table design problem. What happens if you need to
add a product type? It sounds like your design will force you to change the
design of your table. You should have a separate table that lists Product
Types and use what I call a "linking" table to specify which vendors have
which product types. Your design should look like:

tblVendors: VendorID, VendorName, VendorAddress, etc.

tblProductTypes: ProductTypeID, ProductType, etc.

tblVendorProductTypes: VendorID, ProductTypeID, etc.

With this design, adding a product type is easy - just add a record to
tblProductTypes and rows in tblVendorProductTypes to indicate which vendors
now carry that product type.

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
chicagoro said:
I developed a data base for all my vendors. There are many fields where I
Click to expand...
check a box if the vendor has that particular type of product. I can't
figure out how to sort by the checked boxes. When I open query design and
leave checked only one or two boxes in the hopes of generating a list of
only the vendors who carry that product, it does not work.
 
Back
Top