|
|
|
|
|
|
|
|
|
|
version 6.0 (Modified)
RELATE MANY SELECTION (field)
| Parameter | Type | Description | |
| field | 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.
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)
See Also
QUERY, RELATE ONE, RELATE ONE SELECTION.
|
|
|
|
|
|
|
|
|
|