Home >

On this page

AX1009

Using drop-down lists in Formatted Grids

You can display a drop-down list in a Formatted Grid component by setting up a cell in the Grid data source to use the Select content tag. The Select tag defines the source of the list, as well as other list options. The list can be sourced as follows:

  • From a column in a table
  • From an Axiom query defined in the source file
  • From a ComboBox data source defined in the source file

The following topics explain how to set up a Select tag using each of these list sources. The available parameters and setup requirements vary depending on which list source is used.

NOTE: For spreadsheet-formatted grids, it is also possible to create a drop-down list using Excel's Data Validation feature. This approach has fewer options, but may be appropriate for simple lists that do not relate to data stored in Axiom Software. For more information, see Using Data Validation in spreadsheet-formatted grids.