RAD Studio VCL Reference
ContentsIndex
PreviousUpNext
TADOTable.MasterFields Property
TADOTable Class | TADOTable Members | ADODB Namespace | Description | See Also
Collapse All

Specifies field or fields on which a Master-Detail link is based.

Pascal
property MasterFields: WideString;
C++
__property BSTR MasterFields;
Description

Use MasterFields after setting the MasterSource or DataSource property to specify the names of one or more fields in another, master, dataset that are used to establish a Master-Detail relationship between this dataset and the master dataset. The master dataset is specified by assigning its data source to the MasterSource or DataSource property. 

MasterFields is a string containing one or more field names in the master dataset. When the datasets are related based on two fields, separate field names with semicolons:

Copy Code
ADOTable2.MasterSource := DataSource1;
ADOTable2.MasterFields := 'CustID;SaleDate'

 

Copy Code
ADOTable2->MasterSource = DataSource1;
ADOTable2->MasterFields = "CustID;SaleDate"

Each time the current record in the master dataset changes, the new values in those fields are used to select corresponding records in this table for display.

Note: At design time, use the Field Link designer to establish the master-detail relationship between two tables.
 

See Also
Copyright(C) 2009 Embarcadero Technologies, Inc. All Rights Reserved.
What do you think about this topic? Send feedback!