Filtered pick lists

Filtered pick lists aid data entry by creating a parent-child relationship between two consecutive pick list fields in a form or datasheet in iBase so that the selection of a value in the parent list limits the values that can be selected by the user in the child list to only those that are relevant or suitable. This can speed up data entry and ensure consistency in the database.

You define the parent-child relationship between two pick lists in iBase Designer and then assign groups of items in a child list to each item in the parent list. See Editing filtered pick lists.

Note: The assignment of items can also be created and edited in iBase by any user with sufficient permissions.

The child list can be thought of as an amalgamation of several sublists, each one relevant for a single item in the parent list.

You can arrange filtered pick lists into a hierarchy of any number of levels, such that the value selected in the first list filters the available values in the second list, and the selected value in the second list then filters the values available in the third, and so on. It is most common for filtered pick lists to consist of just a parent and a child.

Note: You can use a child pick list in an entity type, link type or datasheet without its parent list. The pick list behaves as an ordinary pick list, with all its values available for selection, sorted alphabetically. In addition two consecutive pick lists in a form or datasheet will only function as parent and child, if you explicitly set them up to behave in that way in iBase Designer.