W
WoodGuy
Hi guys,
I have looked in the posts for this problem, but I guess I am not asking the
right questions.
I use Access 2003.
I have the typical setup for products …combo box A to select a category for
a product list in combo box B based on a query.
My problem is that my products can be in multiple categories and I am having
trouble filtering the list.
My products table is set up so each category has its own field with yes/no
data type (check box).
For instance, on the Main form I select Standard from the Style combo box
then I want the Products combo box on a sub form to show the products with
the Standard categories checked yes and in some cases I need more than one
category that is checked yes to be the result.
I tried “reverse engineering†the Northwind data base, but it only uses a
single category for each product.
Can I do this with a single query or do I need different queries for each
category?
I can get more specific, but I am hoping for a light-bulb moment.
(You guys must really be sick of hearing about combo boxes!)
Thanks for helping.
I have looked in the posts for this problem, but I guess I am not asking the
right questions.
I use Access 2003.
I have the typical setup for products …combo box A to select a category for
a product list in combo box B based on a query.
My problem is that my products can be in multiple categories and I am having
trouble filtering the list.
My products table is set up so each category has its own field with yes/no
data type (check box).
For instance, on the Main form I select Standard from the Style combo box
then I want the Products combo box on a sub form to show the products with
the Standard categories checked yes and in some cases I need more than one
category that is checked yes to be the result.
I tried “reverse engineering†the Northwind data base, but it only uses a
single category for each product.
Can I do this with a single query or do I need different queries for each
category?
I can get more specific, but I am hoping for a light-bulb moment.
(You guys must really be sick of hearing about combo boxes!)
Thanks for helping.