Using Filtered Pick Lists to Enter Data

Filtered pick lists contain a list of available values determined by the selection of a value in the pick list above. When you are entering data in a record or datasheet and there are two consecutive pick lists, the value entered in the first pick list may control the values available for selection in the one below it.

The relationship between a parent and child pick list is defined in iBase Designer. Only a pick list which has been assigned a parent pick list and is also directly below its parent pick list in the data record or datasheet is filtered.

Note: A filtered pick list may be used elsewhere as an ordinary pick list, when it is not directly below its assigned parent list.

Filtered lists can be of two types, depending on the field data type:

• Suggested From Code List pick lists allow you to enter any value

• Selected From Code List pick lists force you to choose a value in the list