[!] Limited Selection List

Parameter is a comma separated list (without quotes) of the options made available to the user and 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 it 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:

Alternatively the list may also come from 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.

Example:

   [!] {MemTab.Person|*|FirstName Value='Alias'}

Sort:

This allows a Field other than the display Field to be used for the sort, and optionally to use no sort at all.

Examples:

   [!] {MemTab.Person|*|FirstName Sort='Alias'}
    [!] {MemTab.Person|*|FirstName Sort='#Alias'}
    [!] {MemTab.Person|*|FirstName Sort='-#Alias'}
    [!] {MemTab.Person|*|FirstName Sort=''}
    [!] {MemTab.Person|*|FirstName Value='Alias' Sort='Alias'}

IfLenFld

Specify a Field Name to use in a simple "KeepIf Field has any length to it" (i.e. Keep if it is True). Sorry, it can't handle more complex criteria, we are out of quote depth to specify further sub-strings to compare with!

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.

Example:

[!] , {MemTab.Person|*|FirstName Value='Alias'}

Display

In addition to the {Value} Display syntax, [Value] Display may be used instead. This allows the use of Value/Display pairs to be used in the Prepend and Append Options where the use of {} would otherwise cause problems due to Field name replacements.

Example:

"`[!] {Test1} Name1 - Price1, {Test2} Name2 - Price2"