Subject How to synchronize 3 grids (N-M relation) ?
Author pepmallorca
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,