TABLE domains

TABLE domains are dynamic sets of values based on the values in a column of a table. This means that they allow fields in one application to be validated against other fields in the product.

The domain specifies the object that you want to validate against. It also specifies a Validation WHERE clause that defines the 1:1 relationship to a record in the child table object.

To learn more about data structures and relationships, you can view information in the Object Structures application.

Be aware of the level at which data is used. For example, an asset is added at the site level, so it is possible that identical asset identifiers are used in more than one site. For that reason, when you add the clause to select the assetnum, you also specify a site identifier.

Example

You can use a TABLE domain to present a valid list of records from the PERSON table to be typed in the OWNER field on a service request.