RAD Studio VCL Reference
ContentsIndex
PreviousUpNext
TField.LookupKeyFields Property

Identifies the field or fields in the lookup dataset to match when doing a lookup.

Pascal
property LookupKeyFields: WideString;
C++
__property BSTR LookupKeyFields;

Only use LookupKeyFields on field components with a FieldKind of fkLookup. LookupKeyFields are the fields in the index of the LookupDataSet whose values must match the KeyFields in the field component's DataSet

To specify more than one field, separate each field name with a semicolon. The fields specified in LookupKeyFields must be of the same types as the corresponding fields in KeyFields, or the lookup can't work. 

Matching the values of the LookupKeyFields in the LookupDataSet with the values of the KeyFields in the DataSet determines a specific record in the LookupDataSet. The Value of the field component is the value of the LookupResultField in the indicated record. 

 

FieldKind 

KeyFields 

Lookup 

LookupDataSet 

LookupResultField 

Value 

DataSet 

Defining a Lookup Field

Copyright(C) 2008 CodeGear(TM). All Rights Reserved.
What do you think about this topic? Send feedback!