SET WINDOW OF RELATION

Purpose

Activate a relational window

Syntax

SET WINDOW OF RELATION [IN <alias>] TO [<window-name>]

[COMMAND EDIT | BROWSE [<qualifier>] | DO <procedure | program>]

See Also

BROWSE, DEFINE WINDOW, EDIT, Function Keys, INDEX, SET INDEX, SET ORDER, SET RELATION, SET WINDOW OF BROWSE, SET WINDOW OF EDIT, SET WINDOW OF MEMO, USE

Description

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.

Example

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

Products

Recital