4D Doc Center : RELATE MANY SELECTION

Home

4D v14.3

RELATE MANY SELECTION


RELATE MANY SELECTION ( aField )

Parameter	Type	Description
aField	Field	Many table field (from which the relation starts)

Description

The RELATE MANY SELECTION command generates a selection of records in the Many table, based on a selection of records in the One table, and loads the first record of the Many table as the current record.

Note: RELATE MANY SELECTION changes the current record for the One table.

Example

This example selects all invoices made to the customers whose credit is greater than or equal to $1,000. The [Invoices] table field [Invoices]Customer ID relates to the [Customer] table field [Customers]ID Number.

  ` Select the Customers

 QUERY([Customers];[Customers]Credit>=1000)

  ` Find all invoices related to any of these customers

 RELATE MANY SELECTION([Invoices]Customer ID)