Monday, April 27, 2009

Supporting master/detail relationships

You can create master/detail relationships between client datasets in your client application in the same way you set up master/detail forms in one- and two-tiered applications.
Creating master/detail forms
A table component’s MasterSource and MasterFields properties can be used to establish one-to-many relationships between two tables.
The MasterSource property is used to specify a data source from which the table will get data for the master table. For instance, if you link two tables in a master/detail relationship, then the detail table can track the events occurring in the master table by specifying the master table’s data source component in this property.

The MasterFields property specifies the column(s) common to both tables used to establish the link. To link tables based on multiple column names, use a semicolon delimited list:

Table1->MasterFields = "OrderNo;ItemNo";

To help create meaningful links between two tables, you can use the Field Link designer.
example of a master/detail formBuilding an Example master/detail form

No comments:

Post a Comment