Assign a PickList to a Cell

Once a PickList has been defined (refer to Using PickLists) it can be assigned to cells within the datasheet for use during data entry:

1. While in the Datasheet Design window, right-click on any cell that has already been mapped to a database field to display a pop-up menu:

   

2. Select the Add Picklist option, then select the PickList name from the sub-menu.

3. To define new PickLists select Add Picklist > Add New PickList and in the resulting text box enter the name of new picklist to be added, then press enter (to define new items or modify existing items in a PickList refer to Using PickLists).

   

4. To delete an existing picklist select Delete Picklist from the pop up menu.

5. To edit the values in an existing picklist select the Edit Pick List Values from the menu. The PickList edit window will be displayed, enabling additional values to be added, edited or changed in the selected PickList.

   For example:

   

Refer to Using PickLists for further information on editing PickLists.