Define MasterFieldLinks in Code

Tech Tip: Define Master/Detail DataPipeline Links in Code

Defining a Master/Detail relationship for a DataPipeline requires that the detail pipeline have the
following properties defined:

1. MasterDataPipeline

2. MasterFieldLinks

At Delphi design-time you can use the object inspector and the DataPipeline’s FieldLinks editor to define
the master/detail relationship.

The following example illustrates how to define the master/detail relationship dynamically at run-time.

var
 lFieldLink: TppMasterFieldLink;


begin

  {define the master/detail pipeline relationship}
  plDetail.MasterDataPipeline := plMaster;

  {create a new field link }
  lFieldLink := TppMasterFieldLink.Create(nil);

  lFieldLink.Parent := plDetail;

  {assign the detail field name}
  lFieldLink.DetailFieldName := 'CustNo';

  {assign the master field name}
  lFieldLink.MasterFieldName := 'CustNo';

end;

Note: The DataPipeline linking requires the records in the detail dataset to be ordered by the linking fields. In the above example, the detail data must be ordered by CustNo.