Newbie Q: Field set-up for Category & sub-category

[linkhunter]

Hi there!

I'm making my first attempt at a contact database and am not sure

exactly how to do this...

Each contact will have a category and a sub-category. Each category

choice has specific sub-categories under it. (ie. Cat- Food & Beverage

Related; Sub-Cat: Caterer, Bartender, etc) Each category and

sub-category also have specific ID numbers.

How do I create the fields so that in data entry the main category can

be chosen and displayed in the field and then the corresponding sub-categories are available to be selected as well in another field?

Any and all help is appreciated.

Regards,

Julia

[LiveOak]

First, the Categories and Subcategories need to be in a table (not just entered into a value list). The Category field is setup to display as a dropdown list or menu using values from the Category field in your new table. A relationship is setup between your Category field and the Category field in the new table of values. Next setup the field display for Subcategory. In this case the value list for Subcategory is setup to restrict the displayed values to those related to the Category.

Perhaps and example is better, one is attached.

-bd

Example.zip