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. 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 Field Dependencies for details.