Subject MasterSource - I think I need 2 Datasets
Author Eric Handbury
Hello,

I have a complicated master/detail relationship where (it seems like) I
need more than 1 MasterSource.

Table: LENDER
Key: LENDERKEY

Table: STEPS
Key: STEPSKEY
Fields: LENDERKEY
CATEGORYKEY

Table: CATEGORY
Key: CATEGORYKEY

I have a Master/Detail setup on LENDER -> STEPS. This works fine,
however, this gives me all the STEPS records associated with that LENDER.
I also need to subset this using CATEGORY. So that I want to display in a
grid all the STEPS associated with that LENDER and that CATEGORY. The
user can select another CATEGORY and get another set of STEPS records.
(Still with the same LENDER).

So how do you generate a subset of a master/detail relationship?

TIA. Eric.