Previous Topic: Multiple-Record Panel Design with a Restrictor

Next Topic: A1 to B1

Virtual Fields and Restrictors on Subfiles

Some special considerations arise for subfile displays when there are virtual fields on the subfile record associated with a relation for which all of the keys are specified as restrictor parameters.

The following examples show the effect of restricting and not restricting a subfile’s virtual fields onto the header format.

Virtual Fields and Restrictors on Subfiles

Different results are obtained if the virtual fields are present in the access path of the function due to the virtualization of fields that are virtualized in a related file. For example, Customer Name is a virtual on Order Header and is re-virtualized to Order Detail. Two possible differences are:

The virtual fields are restricted: They are removed from the individual subfile records and are placed on the subfile control with the restricted fields. This happens if the virtual fields associated with the keys also are restricted.

Virtual Fields and Restrictors on Subfiles (2)

The virtual fields are not restricted: They remain on the individual subfile records. This happens if the fields are defined as virtual fields on the access path of the function file but are not present on the access path of the referenced file that is restricted.

Virtual Fields and Restrictors on Subfiles (3)

The access path combinations for restrictor parameters are:

Virtual Fields and Restrictors on Subfiles (4)