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.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)
See also
QUERY
RELATE ONE
RELATE ONE SELECTION
Properties
| Command number | 340 |
| Thread safe | ✓ |
| Changes current record | |
| Changes current selection |