3.55.1.19 - odd lookup field behaviour when using SDAC

[luis_augusto]

Suppose three tables:

A master for C
B having a lookupresultfield from C
C Detail for A

1. Cursor on A never changes
2. lookup keyfield in B is a different field than masterid in A->C
3. lookupcache is off

in a dblookupcombobox it works fine.
but, in a dbgrid column nothing is displayed

if I turn on lookupcache:

in a dblookupcombobox it works fine.
but, in a dbgrid column some rows are displayed, others are not

when using Paradox tables, this does not happen (if lookupcache is on)

has anyone had this kind of issue? Is there a solution for it?

[Ikar]

Try to split C table into two tables C1 for lookup and C2 for detail.

[luis_augusto]

The reason why C is detail for A is that the set of data I am allowed to display in the lookup column is bounded by the masterid value.
What I can´t understand is why it works fine for DBlookupcombobox but not for dbgrid columns.
Thanks, anyway for the tip. I suppose I can adapt the code to work around this bug.

[Guest]

Try to split C table into two tables C1 for lookup and C2 for detail.

interesting