RELATE MANY SELECTION

version 6.0 (Modified)

RELATE MANY SELECTION (field)

Parameter	Type		Description
field	Field		Many table field (from which the relation starts)

The command RELATE MANY SELECTION 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.

Warning: Do not use this command inside a transaction.

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)

QUERY, RELATE ONE, RELATE ONE SELECTION.