Table Descriptors and Generator Preferences

1
Table Descriptorsand Generator Preferences

• Compensating for Meaningless Primary Keys

2
Default Links and Descriptors
Its time to run the Generate Default Links
utility. You can do more with this tool . . .
Make lookups more descriptive
3
Descriptors Add Clarity
Foreign Key Values
Titles

Title Number
123
4
Setting a Descriptor

• Set a column as a descriptor

5
Setting More than One Descriptor
6
Descriptor Columns and the Default Link Utility
7
Setting Descriptors for Employees and Departments
8
Database has changed

• So Regenerate it with the Generate Database from
  Server Module Utility just in case.

9
Create a New Module
10
Module Component Data Wizard
11
Module Component Display Wizard
12
Generate Default Links
13
Module Diagram
14
The Generated Form
15
Layout Problem

• Generator Preferences
• Steep Learning Curve
• Example this layout is a problem because of the
  item groups tab table usage or GRPUTT

16
Generator Preferences
17
Item Group Preferences
18
Tab Table Options
19
Regenerated Form
BONUS Every vertical item group will line up
this way by default!