Master-detail dataset

Multiple datasets can have master-detail relationship between them.

Let's take an example:

•Master set:  MemberGrade

•Detail set:  Customer

Create a dataset having the grouping field "customer.member_card" using the query wizard.

The query statement is as follows:

SELECT customer.member_card

FROM customer

GROUP BY customer.member_card

Continue with SQL to select customer information by customer.member_card

The query statement is as follows:

SELECT customer.customer_id, customer.fname, customer.lname, customer.phone1, customer.gender

FROM customer

WHERE customer.member_card = '#MemberGrade.member_card#'

Select dataset "Customer" in the data window for the detail set. And set the "Master Set" property value to "MemberGrade".