This is the legacy 4D documentation web site. Documentations are progressively being moved to developer.4d.com
About Relations
RELATE MANY SELECTION
| RELATE MANY SELECTION ( aField ) | ||||||||
| Parameter | Type | Description | ||||||
| aField | Field |
|
Many table field (from which the relation starts) | |||||
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.
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)
Product: 4D
Theme: Relations
Number:
340
Modified: 4D v6
4D Language Reference ( 4D v20 R7)
