Table Configuration → Configuring Tables for Applications → Performing Table Tasks
Most design tasks for primary and auxiliary tables are performed in SBM Composer. Depending on the table type, configuration tasks are performed in the SBM Application Administrator or SBM System Administrator.
Task | Tool | Notes |
---|---|---|
Creating primary tables | SBM Composer | |
Creating non-system auxiliary tables | SBM Composer | |
Creating system auxiliary tables | SBM System Administrator | System auxiliary tables are created by the Create Database Wizard. |
Defining application settings, such as Application tab name and singular item name | SBM Composer | |
Creating fields for all tables | SBM Composer | |
Adding and deleting selections for user-type fields in primary tables (via workflows) | SBM Application Administrator | |
Adding and deleting selections for user-type fields in auxiliary tables | SBM System Administrator | |
Setting default values for user-type, Single Relational, Multi-Relational, and Folder fields in primary tables (via projects) | SBM Application Administrator | |
Setting default values for user-type, Single Relational, Multi-Relational, and Folder fields in auxiliary tables | SBM System Administrator | |
Establishing field dependency relationships | SBM Composer | |
Setting selections for dependent User, Multi-User, or Multi-Group fields for independent User and Single Selection fields primary tables (via projects) | SBM Application Administrator | |
Setting selections for dependent User, Multi-User, or Multi-Group fields for independent User and Single Selection fields in auxiliary tables | SBM System Administrator | |
Specifying fields for the Advanced Search page in the SBM User Workspace | SBM Composer | Select the Appears on Searches for This Table check box located on the Options tab for each field in SBM Composer. |
Defining custom field section titles, item details labels, and report privilege category labels for individual primary and auxiliary tables | SBM Composer | |
Enabling caching for auxiliary tables | SBM System Administrator | |
Specifying record locking settings for primary and auxiliary tables | SBM System Administrator | |
Allowing data import for primary and auxiliary tables | SBM System Administrator |
Copyright © 2001–2016 Serena Software, Inc. All rights reserved.