Subject Re: [IBO] MasterSource - I think I need 2 Datasets
Author lester@lsces.co.uk
> Table: STEPS
> Key: STEPSKEY
> Fields: LENDERKEY
> CATEGORYKEY
>
> Table: LENDER
> Key: LENDERKEY
>
> Table: CATEGORY
> Key: CATEGORYKEY

I process this sort of problem in the OnDataChange event.

Grid is driven by
SELECT * FROM STEPS
WHERE LENDER = :LENDER
AND CATEGORY = :CATEGORY

And then when either the LENDER or CATEGORY selection are
changed, just change the the parameters on the STEPS query.
With RefreshOnParamChange set, then the grid will update. It
also allows me to do some other checks before processing the
change.

There is probably a more elegent way, which nodoubt someone
will supply.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services