Limiting choices in a data field

[Johnny777]

Hello

I am working on a contacts database which requires companies to be classified by Category and then sub-category. So for example, emergency services would be sub categorised as fire ,police etc.

Basically I would like to limit the choices on the sub-category field according to what is entered in the main category field ie if category emergency services is selected then only choices related to that category are available (by drop down list), in the sub category.

If someone could point me in the right direction re scripting I would be very grateful

[Fitch]

Take a look at Basic Conditional Lists.

[Johnny777]

Hi

I have downloaded this file and all has become clear

Many thanks