Subject How to synchronize 3 grids (N-M relation) ?
Author pepmallorca

How can I synchorize an N-M relation, in 3 grids?

I explain:

Suppose I have 3 tables:


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?