Applications → Managing Tables → About Tables → About the Value Display Format
The value display format setting controls many features:
Guidelines for the value display format follow:
You can set the order in which the fields appear, add text to the format, and use HTML tags to format the content. For example, specify this value display format:
<Title> - <b><Owner></b>
Items from the table will appear in search results as follows:
ITEM10098 This is the title of the item - Item's owner
The value display format determines how values appear in Single Relational and Multi-Relational selection lists on forms. For example, the value display format for a Versions table might be <Product Name> <Version Name>.
Relational field values based on auxiliary tables are sorted by the table's value display format. To change the order in which values sort for the Relational field, modify the value display format for the auxiliary table.
The value display format determines the fields that are searched and the order in which values are searched for the Relational Field Value Lookup form.
For example, if you add the Item ID and Description fields as the value display format for a primary table, users can search for values by item ID or keyword for relational fields that reference the table.
If you specify multiple fields for the value display format for auxiliary tables, the fields are automatically shown in the first column of search results for the Manage Auxiliary Data feature.
This enables users to sort results by the value display format. For example, if the column contains a Title and First Name field in that order, results may appear as:
Manager, Adam
Manager, Bruce
Manager, Carol
Copyright © 2007–2019 Micro Focus or one of its affiliates. All rights reserved.