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 SBM Work Center 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