About lookup lists and external data

Meridian can present lists of predefined values from which users can select when editing property pages or wizard pages. Depending on your specific needs, Meridian offers three types of value lists from which to choose:

• Lookup lists: Suitable for small lists that seldom change. Lookup lists may have only one column of data. The data is stored within the Meridian vault and may be edited with the Configurator. Users with the Can Type Unlisted Values privilege for a specific lookup list may type new values with the Meridian client applications.
• Tables: Suitable for moderate to large lists. Tables may have multiple columns of data. The data is stored outside of the Meridian vault in Microsoft Access format. Users cannot add new values with the Meridian client applications.
• Queries: Suitable for lists of data that reside in existing external data sources. Users cannot add new values with the Meridian client applications.

Assigning a value list to a property is done on the Validation page of the property in Configurator, as described in Restricting user input.

Configuring each type of value list is described in the following topics.