[!] Limited Selection List

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. 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". When used with a Top Query in MOX, this will ensure the field value matches one of the options, if not it will throw a run time error.

Description:

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.

 

Extensions to Database Lookup Paths

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.

Examples:

[!] One, Two, Three
[!] Checkbox
[!] Option One, "Option Two, with a comma", Option Three
[!] {Test1} Name1 - Price1, "{Test2} Name2, Price2"
[!] {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'}