TField.LookupDataSet Property

Identifies the dataset used to look up field values.

Pascal

property LookupDataSet: TDataSet;

C++

__property TDataSet LookupDataSet;

Description

Use LookupDataSet to specify the dataset to use for looking up field values in a field with a FieldKind of fkLookup.

Note: LookupDataSet can't refer to a unidirectional dataset.

When a field component is a lookup field, the Value of the field component is the value of the LookupResultField in the LookupDataSet. The record in the LookupDataSet that contains the correct value is found by matching the LookupKeyFields in the LookupDataSet with the current values of the KeyFields in the DataSet.