APG with Table Relationships
This is an enhancement of the existing APG. With this enhanced APG, is possible to create Browse programs quickly with the following:
-
Multiple Subforms (for 1:N relationships)
-
Multi-level Subforms (for 1:N relationships) and
-
Linked Tables (for 1:1 and N:1 multiple and multi-level relationships)
The Browse programs are created based on the selected relationship(s) from the APG Relationship Tree.
The fields of the APG Relationships wizard are as follows:
|
|
|
|
Table Name
|
The selected source table name on which the APG was invoked.
|
|
Program Type
|
The type of program you want to create using the APG:
-
Browse
-
Rich Client
-
Web Client
By default a Browse program is created at the end of the list of programs in Program Repository.
|
|
Program Name
|
The name of the created program. You can change the default program name.
|
|
Folder
|
The folder in which you would want the program to create.
|
|
Index
|
The index of the parent table from the pick list. Its functionality is as same as existing APG.
|
|
Style
|
The style of program:
The default style is Line.
|
|
Use Model
|
The model from the pick list. Its functionality is as same as existing APG.
|
|
Form Size
|
The form size:
-
As Model
-
As Content
-
As Content within MDI.
Its functionality is same as existing APG > Style.
|
After setting the desired options on the APG Relationships dialog when you click on OK button, a program is automatically generated and placed in the list of Program Repository at the end.
If you have defined a 1:1 relationship, Current Table and Referenced Table are linked using a Link Query.
Since version: 4.7
Related Topics
How Do I Create a Browse Program for a Data Source Having Table Relationships?
Relationships Repository
