In the View Design Data Entry dialog, you can choose which database columns to include in a view, and what order theyʼll appear in. The fields you can choose from appear in the Available Fields list. This list, however, presents the column names used internally within Manager. For example, in the Customer list, to include the Date field in a view, you must select the Available Field CREATIONDATE. (You can redefine the field name for a specific view in the Header field on the Column Layout tab.) To find the corresponding database name for a field used in list windows and data dialogs, consult the list for the table youʼre working with:
In some lists, views can also display data from other related lists. For example, in a view of the Inventory list, you can add a column to show the Location where an inventory item is stored. This data comes from the Inventory Location list, where it is stored in a field called Name.
References to such linked tables appear in the Available Fields list with two-letter prefixes indicating the tables they represent. For example, to create a column for the Location field from the Inventory Location list, assign the Available Field ILNAME.
↑ The View Manager