Subject | How to synchronize 3 grids (N-M relation) ? |
---|---|
Author | pepmallorca |
Post date | 2002-02-22T19:51:06Z |
Hello:
How can I synchorize an N-M relation, in 3 grids?
I explain:
Suppose I have 3 tables:
TBLA(#idA,desa)
TBLB(#idB,desb);
TBLC(#A,#B,#idC);
I want to view the 3 queries in 3 grids, and when I moved into GRIDA,
refresh GRIDC, and when I moved into GRIDB refresh GRIDC.
The query TBLC is the next:
select idc from TLBC where a=:idA and b=:idB
It's similar like an detail with 2 masters.
I can simulate the QUERY C, like an query with an MasterSource (for
example A), and the other like an parameter, but it doesn't refresh
good. Another solution for this problem?
Thanks,
How can I synchorize an N-M relation, in 3 grids?
I explain:
Suppose I have 3 tables:
TBLA(#idA,desa)
TBLB(#idB,desb);
TBLC(#A,#B,#idC);
I want to view the 3 queries in 3 grids, and when I moved into GRIDA,
refresh GRIDC, and when I moved into GRIDB refresh GRIDC.
The query TBLC is the next:
select idc from TLBC where a=:idA and b=:idB
It's similar like an detail with 2 masters.
I can simulate the QUERY C, like an query with an MasterSource (for
example A), and the other like an parameter, but it doesn't refresh
good. Another solution for this problem?
Thanks,