When editing data in the data grid, we sometimes need to have a list of specific values for certain columns, with ability to pick needed value from the list without typing the text manually. Here is how to specify such a pick list in Database Tour:

  1. Open the database.
  2. Open the needed table and switch to Data page.
  3. Right-click the needed column and choose Column Properties | Pick List....
  4. If clipboard contains a list already, click Paste from Clipboard button, otherwise add needed values manually. Click OK.

In the context menu of the data grid, there is an ability to save the column definitions to file and load them for this table at a later time.

See also

 Data View