Use MasterFields to identify the fields in another (master) dataset that can be used as link fields in a master/detail relationship. MasterFields is a semicolon-delimited set of field names, where each name identifies a field in the master dataset. The master dataset is the dataset associated with the datasource specified by MasterSource. Each of the fields in MasterFields must be matched to a corresponding field from the IndexFieldNames property.  

At design-time, double-click on the MasterFields property in the Object Inspector to use the Field Link designer to help you define the master/detail relationship. You can only use the Field Link designer if you have already specified the IndexName or IndexFieldNames property and the MasterSource property. 

IndexFieldNames 

IndexName 

MasterSource 

Making the Table a Detail of Another Dataset 

Setting Up Master/detail Linked Cursors