[!] 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.

Fixed Lists:

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.



[!] 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