This macro displays a list of predefined choices and inserts one of the data fields within the phrase placeholder. Several standard Windows controls are supported - ListBox, DropDown, ComboBox, Radio and Lookup search. Input selection dialog window will appear when command is executed to allow user input.


The macro is similar to a Selection Form macro but much more powerful as it allows the output multiple fields from the table with a single selection.



Name - The unique name of the field. The field name cannot contain blanks or special characters. Two fields with the same name and of the same type are treated as one - the user input is only required once.

Description (optional) - Description of a field to be shown on the input dialog.

Type - Select one of the standard Windows selection controls - ListBox, DropDown, ComboBox, Radio and Lookup search. Lookup search should be used for larger tables.

Table - Select a table from the list or select New to create a new table. Select a folder button to open a table from a disk. Select a folder button to rename or delete tables.

Selections - List of available selections, one selection text per line. Right click to open a context menu to add, edit or delete table cells or columns. The selection or search is always performed on the first column (Selections).


To improve visibility, add a description prefix to selections. In such case only description will appear on a input selection dialog. The default description separator is "::" and can be changed in Preferences > Text Expander.


Return column(s) (optional) -  Comma delimited list of one or more table columns to be returned as an output. Leave this field blank to return the all columns.

Output separator (optional) - Specify separator characters to be shown between multiple return fields..

Force Query (optional) - If multiple Selection Table macros in the same command are using the same table, FastKeys only asks for the user input once. Select this option to force a separate user input.

No output (optional) - Enable this option to instruct FastKeys not to output the value. This is useful for using the values later in the conditional statements, calculations or scripts.

Output format (Optional) - The macro output can be further processed by several additional macro functions. See: Output format


Select OK to insert a %TABLE_Name% macro field into the command. Double-click on the field name to open the dialog and edit the macro properties again.


In the following example, user will be asked to select a patient's gender to further adjust the phrase.

The patient is associated with several symptoms. %TABLE_Gender1% is advised to stay home. %TABLE_Gender2% blood pressure is normal.


TABLE_Name field variables can also be used in the conditional statements, calculations or scripts.