table descriptors and generator preferences
DESCRIPTION
Table Descriptors and Generator Preferences. Compensating for Meaningless Primary Keys. LOV. LOV. 1139 1003 1292. Angela Joni Sue. Default Links and Descriptors. It’s time to run the Generate Default Links utility. You can do more with this tool. Make lookups more descriptive. LOV. LOV. - PowerPoint PPT PresentationTRANSCRIPT
![Page 1: Table Descriptors and Generator Preferences](https://reader033.vdocuments.us/reader033/viewer/2022051316/56813d06550346895da6ad9f/html5/thumbnails/1.jpg)
Table Descriptorsand Generator Preferences
Compensating for Meaningless Primary Keys
![Page 2: Table Descriptors and Generator Preferences](https://reader033.vdocuments.us/reader033/viewer/2022051316/56813d06550346895da6ad9f/html5/thumbnails/2.jpg)
Default Links and DescriptorsIt’s time to run the Generate Default Links utility. You can do more with this tool . . .
113910031292
LOV
AngelaJoniSue
LOV
Make lookups more descriptiveMake lookups more descriptive
![Page 3: Table Descriptors and Generator Preferences](https://reader033.vdocuments.us/reader033/viewer/2022051316/56813d06550346895da6ad9f/html5/thumbnails/3.jpg)
Descriptors Add Clarity
Titles
Title Number
Foreign Key ValuesForeign Key Values
123
123245343412
LOV
Users would like to see the titles instead of meaninglessnumeric primary key values
LOVGone with the MaskThe Little Conan...
Title describes Title Number,the primary key. Title is said to be a . . .
Descriptor
Gone with the MaskThe Little ConanThe Magnificent 8 1/2
LOV
![Page 4: Table Descriptors and Generator Preferences](https://reader033.vdocuments.us/reader033/viewer/2022051316/56813d06550346895da6ad9f/html5/thumbnails/4.jpg)
Setting a Descriptor
HOLLYWOOD: Column Properties
Default Display-
Descriptor Sequence
. . .. . .
. . .. . .1
• Set a column as a descriptor
![Page 5: Table Descriptors and Generator Preferences](https://reader033.vdocuments.us/reader033/viewer/2022051316/56813d06550346895da6ad9f/html5/thumbnails/5.jpg)
Setting More than One Descriptor
LOV
Descriptor Sequence
DepartmentColumn:
DepartmentColumn:
2Descriptor Sequence
Name
1
Education
Consulting
Sales
Location
2
Aylmer
Rotterdam
London
Location
1
Education
Consulting
Sales
Name
2
Aylmer
Rotterdam
London
![Page 6: Table Descriptors and Generator Preferences](https://reader033.vdocuments.us/reader033/viewer/2022051316/56813d06550346895da6ad9f/html5/thumbnails/6.jpg)
Generate Default Links...
Lookup Links
Create Table Usages for Descriptor Columns
Descriptor Columns and the
Default Link UtilityEMPLOYEES
EMPLOYEES DEPARTMENTS
![Page 7: Table Descriptors and Generator Preferences](https://reader033.vdocuments.us/reader033/viewer/2022051316/56813d06550346895da6ad9f/html5/thumbnails/7.jpg)
Setting Descriptors for Employees and Departments
![Page 8: Table Descriptors and Generator Preferences](https://reader033.vdocuments.us/reader033/viewer/2022051316/56813d06550346895da6ad9f/html5/thumbnails/8.jpg)
Database has changed
• So Regenerate it with the Generate Database from Server Module Utility just in case.
![Page 9: Table Descriptors and Generator Preferences](https://reader033.vdocuments.us/reader033/viewer/2022051316/56813d06550346895da6ad9f/html5/thumbnails/9.jpg)
Create a New Module
![Page 10: Table Descriptors and Generator Preferences](https://reader033.vdocuments.us/reader033/viewer/2022051316/56813d06550346895da6ad9f/html5/thumbnails/10.jpg)
Module Component Data Wizard
![Page 11: Table Descriptors and Generator Preferences](https://reader033.vdocuments.us/reader033/viewer/2022051316/56813d06550346895da6ad9f/html5/thumbnails/11.jpg)
Module Component Display Wizard
![Page 12: Table Descriptors and Generator Preferences](https://reader033.vdocuments.us/reader033/viewer/2022051316/56813d06550346895da6ad9f/html5/thumbnails/12.jpg)
Generate Default Links
![Page 13: Table Descriptors and Generator Preferences](https://reader033.vdocuments.us/reader033/viewer/2022051316/56813d06550346895da6ad9f/html5/thumbnails/13.jpg)
Module Diagram
![Page 14: Table Descriptors and Generator Preferences](https://reader033.vdocuments.us/reader033/viewer/2022051316/56813d06550346895da6ad9f/html5/thumbnails/14.jpg)
The Generated Form
![Page 15: Table Descriptors and Generator Preferences](https://reader033.vdocuments.us/reader033/viewer/2022051316/56813d06550346895da6ad9f/html5/thumbnails/15.jpg)
Layout Problem
• Generator Preferences• Steep Learning Curve• Example: this layout is a problem
because of the item group’s “tab table usage” or GRPUTT
![Page 16: Table Descriptors and Generator Preferences](https://reader033.vdocuments.us/reader033/viewer/2022051316/56813d06550346895da6ad9f/html5/thumbnails/16.jpg)
Generator Preferences
![Page 17: Table Descriptors and Generator Preferences](https://reader033.vdocuments.us/reader033/viewer/2022051316/56813d06550346895da6ad9f/html5/thumbnails/17.jpg)
Item Group Preferences
![Page 18: Table Descriptors and Generator Preferences](https://reader033.vdocuments.us/reader033/viewer/2022051316/56813d06550346895da6ad9f/html5/thumbnails/18.jpg)
Tab Table Options
![Page 19: Table Descriptors and Generator Preferences](https://reader033.vdocuments.us/reader033/viewer/2022051316/56813d06550346895da6ad9f/html5/thumbnails/19.jpg)
Regenerated Form
BONUS: Every vertical item group will line up this way by default!