Generate Parent Checks

The Generate parent checks option on the Table Processing menu automatically sets up the related tables for the main table of a procedure body.

The related table settings will depend upon the table processing of previous procedure bodies. For instance, the access mode will be set to Already fetched if a previous procedure body has accessed that table.

Use this feature with discretion. It sets up all of the direct parents of the main parent, whether or not you wish to update them or display their field values.

There can be a severe performance penalty if you use Window access or Multiple Choice, because all the parents have to be fetched for every line in the window. You must fetch the parent if any of its fields are displayed in the window, otherwise it is preferable to use Additional table processing instead of Related table processing if the program logic allows this. You then set up the key fields in Field processing and only the parent for your selected record need be fetched.