Fields

This property makes it easier for users to use search and lookup in a table. For example, if a table's primary key is a numeric identifier that is also used as a foreign key in another table, users must know this identifier to perform a lookup into this table. Using this property, you can link a different search field that is easy to remember (for example, a name or address field) to the numeric primary key field.

Concepts