Information in this section explains how to add and edit a Dynamic Picklist user defined field (UDF). The information is intended for the PCS Axis SysAdmin or a user with SysAdmin user permissions.

A Dynamic Picklist UDF is a dynamic drop-down list with data items that change based on a data item selected in another picklist. This dependency uses a cascading parent/child relationship. For example, selecting a data item in the drop-down list of picklist A (parent) determines which data items are available for selection in the drop-down list of picklist B (child).

Dynamic Picklists are helpful to users when entering data in a data grid or form. It allows for easier and more accurate data entry.

Building a Dynamic Picklist allows you to control the data entered in a field by limiting the choices to those in a pre-defined list. For example, instead of a user typing a lengthy description for sub-station locations throughout the country, you might want to build a Dynamic Picklist with a parent picklist named My Sub-Station Type that includes three associated child picklists labeled My Sub-Station State, My Sub-Station County, and finally My Sub-Station City. Each of these are dependent upon the other and form the Dynamic Picklist.

Building a Dynamic Picklist is a 2-part process. You begin with creating the initial parent picklist as a Standard Picklist and then add and map one or more child Dynamic Picklists. Once this process is complete, you can then add the parent and child picklists in data entry grids/forms, reports, and prompts sent to the Allegro Field Computer.

Topics in this section explain how to add and edit a Dynamic Picklist. They include those in the following list:

As an example to demonstrate how to build a Dynamic Picklist, information in this section uses a 2-level Dynamic Picklist with My Pipeline State as the initial parent picklist and My Pipeline County as the associated child picklist. Although Dynamic Picklists support an unlimited number of child picklists, the example uses one for clarity purposes. The process for adding multiple child picklists is the same as adding one child picklist.