Subcategories based on categories

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

Guest

I have a table "Products" in access with 4 fields:
Primary Key - Product Name - Category - Subcategory
1 - KD32 - TV - PSONY
2 - ST25 - VCR - PHONY

Subcategory field values come from another table "Subcategories" with 2
fields:
Primary Key - Subcategory Name - Category
1 PSONY TV
2 PHONY TV
3 CHONY VCR
4 RONY VCR

Category field values in both Products and Subcategories tables come from
another table "Categories" with 2 fields:
Primary Key - Category Name
1 TV
2 VCR

What i want to do is when i select a Category for a product in table
Products to be able to select only the Subcategories witch have the same as
the Product Category in the field Category (eg when i select TV as products
category to be able to select only from PHONY and PSONY for Subcategory.

Is is possible?
Thanks
 
Your question is the same as that posed by Cyndi just a little while ago,
and the answer is the same.

Essentially what you have to do is reset the 2nd combo's RowSource when you
select a value from the first one. In your case the value you'll pass is the
Category. See if the following page helps:

http://www.pacificdb.com.au/MVP/Code/ComboRS.htm

Graham R Seach
Microsoft Access MCP, MVP
Sydney, Australia
 
Back
Top