Lookup Lists and Lookup List values

Lookup Lists are assigned permissions to determine whether users are permitted to add values to the list and, if so, whether they are prompted to confirm any new value they add. Three broad types of permission can be assigned to a Lookup List:

There are seven permutations of these three broad permissions:

• ReadOnly
• Skip
• ReadIgnore
• ReadWrite
• WriteIgnore
• AutoWrite
• AutoWriteIgnore

System Administrators assign permissions to Lookup Lists with the Lookup Registry entry.

Fields with Lookup Lists can be linked together in a logical, hierarchical relationship, e.g. City / State / Country:

• Selecting a value in the City field:
  • Will automatically complete (auto fill) the other two fields in the hierarchy if there is only one city in the Lookup List with the name selected.

    Example: Melbourne / Victoria / Australia. If Melbourne is the only city of that name in the City Lookup List, when it is selected, the State and Country fields will be populated automatically with Victoria and Australia respectively.

    Note: See Auto Fill Registry entry for details of turning off auto fill of fields in a Lookup List hierarchy.

    Tip: The auto fill feature also functions on single level Lookup Lists. When a value is keyed into a Lookup List field, the value is replaced with the corresponding Lookup List value if a matching entry exists in the Lookup List module. For example, if a Lookup List contains the value IBM and a user enters ibm, the user's text (ibm) will be replaced with the Lookup List value (IBM). This feature can be a useful mechanism to enforce consistent entry of values.

  • Will filter the associated Lookup Lists if there is more than one city in the Lookup List with the same name selected.

    Example: Melbourne / Victoria / Australia and Melbourne / Florida / USA. There are two cities called Melbourne in the City Lookup List, but they are in different Lookup List hierarchies. When Melbourne is selected in the City Lookup List, the State and Country Lookup Lists will be filtered automatically to list only those values associated with Melbourne. Both the State and Country Lookup Lists will each have two values to select from (Victoria and Florida, and Australia and USA respectively). If Victoria is selected from the State Lookup List, the Country field will be populated automatically with Australia.

• Selecting a value in the Country (or State) field will filter values in the Lookup Lists lower down the hierarchy. Selecting Australia from the Country Lookup List will filter values in the State Lookup List to Australian states, and values in the City Lookup List to Australian cities.

A Lookup List is a list of values which have either been used or which are suggested for use in a field. In other words, a Lookup List can be built from values keyed by users into a field and / or it can be pre-loaded with values.

A value can be selected from a Lookup List when running a search, adding or editing a record.

Values in a Lookup List can have one or both of the following attributes:

As a consequence of EMu's support for Unicode, it is important to keep in mind when working with Lookup List values that punctuation and diacritics are significant when comparing values: Zoe and Zoë are different Lookup List values for instance.

System Administrators must be aware of this when setting the Lookup Exact Registry entry.

Note: A detailed examination of EMu's support for Unicode can be found in Support for Unicode.