Hi,

We have a DB app, which allows users to browse a record (call it record A).
This record (A) has a FK to another table, so the FK is a TIB_LookupCombo.

Say the application user was to open the form which allows him/her to browse
the above mention record (A). Say that the application user also opens
another form to edit the content of the FK record (call it record B)
reference by record (A).

Once she/he has modified record (B) and committed the changes. The
application calls RefreshAll() on the query responsible for the dropdown
(TIB_LookupCombo), at this stage I am getting a Singleton error but I am not
sure how this is possible. On the other hand, if I use Unprepare, Prepare
and Execute the error no longer appears, but the TIB_LookupCombo no longer
displays the FK record(B) associated to record (A) as selected, it just
appears as one of the available records in the dropdown.


I am not sure if the above description of the problem is sufficient. If not
please ask for the any further information you require.

Thank you

Daniel.