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)