I've seen this before but let me see if I can find somebody that can fix it...

:>




>Hi everybody, it is a new kid on the block with a problem (what a shock!)
>
>Duh problem:
>
>1. A parent table (Orders) with two 1-1 related children tables (Location and Customer).
>2. A read-only grid with fields from the parent table (order.id, order.description, etc.) and from the children tables (location.name and customer.name).
>3. Occasionally (mostly at startup) the grid will point to (and show) wrong children records.
>4. Forcing numerous refreshes does not work, but skipping record pointer in the parent or the children outside of the grid will eventually "wake up" the relations and the grid will work.
>
>I know that a view would work here, but we cannot use it now, so anybody ever seen this before?
>
>Dariusz