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