Parameter is a comma separated list (using CSV rules and not in quotes) of the options made available to the user which are enforced on save.

Fixed Lists:

• Checkbox: If the Parameter is just the single word Checkbox, then instead of a drop down list with values, the user will be given a single checkbox: If the field is unchecked the value will be blank, and if it is checked the value will be "y".
• Top Query: When this attribute is used with a Top Query in MOX, it will ensure the field value matches one of the options; if not, it will throw a run time error.
• Values & Language: To use different values than labels, for each comma separated pair, specify the value first inside of { } followed by the label. In this case only, the label text may optionally be taken from the Content.Lang table, using the format of {$Content.Lang.Alias$}.

Database Lookup Lists:

To specify non-fixed lists, the list may specify a Database lookup path by placing the path in a set of { }. The Database path may also reference local Field values for one or more of the three parts of the path by enclosing them in a sub-set of { }. In order to return a list all field values within a table, use a * in the Alias position. In this mode, since the lookup values could change and be an issue for historical records, the field value is not enforced on save and this Attribute is strictly for User Interface purposes.

When the database lookup should return a list using the format of separate values from what is to be shown in the drop down display, specify the Field name to use for the Value while specifying the display Field as part of the path.

One or more of the following may be added to the database lookup path as trailing attributes inside the set of { }, in the format of Ext='Value' with spaces between multiple extensions.

• Sort: This allows a Field other than the display Field to be used for the sort, and optionally to use no sort at all
• IfLenFld: Specify a Field Name to use in a simple "KeepIf this field has any length to it" (i.e. Keep if it is True.)
• Prepend / Append: This allows you to add hard coded values before (Prepend) or after (Append) the resulting database lookup path. A common use of these would be to allow for a blank value since it is not possible to have a blank Alias in the Database, which can be be specified with a value of ' ' (see example below.)

Examples:

[!] One, Two, Three
[!] Checkbox
[!] Option One, "Option Two, with a comma", Option Three

[!] {Test1} Name1 - Price1, "{Test2} Name2, Price2"
[!] {Test1} {$Module.Test1$}, {Test2} {$Module.Test2$}

[!] {MemTab.Person|*|FirstName Value='Alias'}
[!] {MemTab.Person|*|FirstName Sort='Alias'}
[!] {MemTab.Person|*|FirstName Sort='#Alias'}
[!] {MemTab.Person|*|FirstName Sort='-#Alias'}
[!] {MemTab.Person|*|FirstName Prepend=' '}
[!] {MemTab.Person|*|FirstName Prepend=' , Fixed Option,'}
[!] {MemTab.Person|*|FirstName Value='Alias' Sort='Alias'}
[!] {MemTab.Person|*|FirstName Value='Alias' IfLenFld='Active'}

TestMe [!] One, Two, Three 'Will through a runtime error if TestMe does not equal one of these values