Hi, I am working on a database for a book dealer. The dealer has about
20 main categories that the books can fall under and about 5 sub
categories for each main one. I want to have a category checkbox
section that will populate the subcategory checkbox based on which
main categories have been selected (2 seperate boxes). Is this
possible.

Would I have two databases two store categories, one for main cats and
another for subs? Any help would be greatly appreciated.

THANKS!!!

Cogswell wrote:

Sorry to take so long geting back on this. I had done this before; it took
me a while to organize my thoughts.

You'll need a separate Categories table, two fields: CatMain and CatSub,
populated with all relevant category and subcategory names. CatMain and
CatSub fields should also exist in your primary table.

Set a relationship between the two tables, using CatMain as the key.

Define Value Lists for each, using the contents of the fields in the
Categories table. Include all values for CatMain; the CatSub VL should be
set to show only related records from the CatMain relationship.

Radio Buttons would be more appropriate for this than checkboxes. A book
can't have more than one catgory/subcategory, can it?

Unless I have totally zoned out on how I did this before, CatSub should
now display a dynamic button array, depending on which MainCat is selected.

Matt