Subject | Re: [IBO] How to synchronize 3 grids (N-M relation) ? |
---|---|
Author | pepmallorca |
Post date | 2002-02-24T18:52:25Z |
> Luis,think
>
> I've looked quite hard at your problem (as originally posted) and I
> you have your master-detail relationships back-to-front for doingwhat you
> ask to do.an
>
> I think DatasetC is, for your requirements, the detail dataset of
> optional master-detail relationship. I believe what you want to dowith
> the three datasets can be done quite simply by swapping theMastersource
> and MasterParamLinks between DatasetA and DatasetB as alternativeDatasetA.idA
> masters. Don't use a table component for DatasetC, use a query:
>
> SELECT idC, A, B, ....
> from TableC
> where A = :ParamA
> and B = :ParamB
>
> When DatasetA is the master, ParamA is the MasterParamLink to
> and ParamB gets its value from DatasetB.idB; and when DatasetB isthe
> master, ParamB MasterParamLinks to DatasetB.idB and ParamA gets itsvalue
> from DatasetA.idA.Hello Helen:
I don't understand exactly what you want I do.
I think my 2 masters are not alternative. Always I need a
combination of the 2 masters (1 field of the first master, and 1
field of the second master), give me the results of the detail.
I tested your code in my program:
SELECT idC, A, B, ....
from TableC
where A = :ParamA
and B = :ParamB
But I can have only one MasterSource, and the result than I get is
empty for me if I write the second condition of the where.
For now I have find another solution, doing another combination of
tables, but I'm interesting in your solution that seems very good,
and it's possibly to solve another problems of this type.
Can you explain a little more with more detail?
Thanks,