1 / 19

Table Descriptors and Generator Preferences

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.

neena
Download Presentation

Table Descriptors and Generator Preferences

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Table Descriptorsand Generator Preferences Compensating for Meaningless Primary Keys

  2. LOV LOV 113910031292 AngelaJoniSue Default Links and Descriptors It’s time to run the Generate Default Links utility. You can do more with thistool . . . Make lookups more descriptive

  3. LOV LOV 123245343412 Gone with the MaskThe Little ConanThe Magnificent 8 1/2 Users would like to see the titles instead of meaninglessnumeric primary key values LOV Gone with the MaskTheLittle Conan Title describes Title Number,the primary key. Title is said to be a . . . Descriptor ... Descriptors Add Clarity Foreign Key Values Titles Title Number 123

  4. HOLLYWOOD: Column Properties - Default Display . . . 1 Descriptor Sequence . . . Setting a Descriptor • Set a column as a descriptor

  5. DepartmentColumn: DepartmentColumn: Name Location Location Name 2 1 1 2 2 Descriptor Sequence Descriptor Sequence LOV Aylmer Rotterdam London Education Consulting Sales Education Consulting Sales Aylmer Rotterdam London Setting More than One Descriptor

  6. Generate Default Links... EMPLOYEES Lookup Links Create Table Usages for Descriptor Columns DEPARTMENTS EMPLOYEES 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 group’s “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!

More Related