RELATE MANY SELECTION

4D - Documentation   Français   English   German   4th Dimension 2004, Command Theme List   4th Dimension 2004, Command Alphabetical List   4th Dimension 2004, Constant Theme List   Back   Previous   Next

version 6.0 (Modified)


RELATE MANY SELECTION (field)

ParameterTypeDescription
fieldFieldMany 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.


4D - Documentation   Français   English   German   4th Dimension 2004, Command Theme List   4th Dimension 2004, Command Alphabetical List   4th Dimension 2004, Constant Theme List   Back   Previous   Next