Subject | Re: [IBO] MasterSource - I think I need 2 Datasets |
---|---|
Author | lester@lsces.co.uk |
Post date | 2002-02-05T07:41:42Z |
> Table: STEPSI process this sort of problem in the OnDataChange event.
> Key: STEPSKEY
> Fields: LENDERKEY
> CATEGORYKEY
>
> Table: LENDER
> Key: LENDERKEY
>
> Table: CATEGORY
> Key: CATEGORYKEY
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