SET WINDOW OF RELATION
Activate a relational window
SET WINDOW OF RELATION [IN <alias>] TO [<window-name>]
[COMMAND EDIT | BROWSE [<qualifier>] | DO <procedure | program>]
The SET WINDOW OF RELATION command activates a window to view and modify data that is related to an active BROWSE or EDIT window.
As the record pointer is moved through the BROWSE or EDIT window, data in <window> is refreshed to show only those records that are related to the parent table. The <window> must be defined with a DEFINE WINDOW command. The cursor may be moved into the related window by using the [FIND NEXT] key to cycle through all related windows. When the window is selected, any operation that is allows with the type of work surface may be used.
The optional IN <alias> qualifier may be used to specify the workarea that SET WINDOW OF RELATION is to work in. If this qualifier is not used, the appropriate workarea must be selected before the SET WINDOW OF RELATION command is issued.
Each workarea may have a SET WINDOW OF RELATION defined. It is required that the SET RELATION command be used to define the relations between the workareas before the SET WINDOW OF RELATION command is issued.
The COMMAND qualifier specifies whether data will be presented in a BROWSE or an EDIT work surface or if a program or procedure will be called. If BROWSE is specified, the related data will appear within the named window in a BROWSE work surface. If EDIT is used the first related record will be shown in an EDIT work surface. If DO is specified, the named program or procedure will be called.
The BROWSE or EDIT command may be customized with any qualifier, by using the <qualifier> option. For example, when specifying BROWSE, you might want to limit the number of fields with the FIELDS qualifier of the BROWSE command.
If the SET WINDOW OF RELATION command is issued without any qualifiers it will be deactivate the related window. To re-activate the related window, issue another SET WINDOW OF RELATION command.
set view to demo set window of relation in accounts to brelation; command browse set window of relation in product to bedit; command edit set window of browse to rbrowse browse noclear