Auxiliary Tables

Auxiliary tables store items that support, but do not follow, a workflow process. Auxiliary items typically contain information that is collected once and used repeatedly. Auxiliary tables allow this information to be stored separately from primary items, making it easily shared and reusable across multiple applications.

Because auxiliary tables typically store static information, they are often used to create relationships between tables. Single Relational and Multi-Relational fields can be added to any auxiliary table or primary table to reference information contained in auxiliary tables. This is the basis for field dependencies, which let you populate selection lists in a selection or relational field type, based on selections in another field. See Configuring Field Dependencies for details.