I have about 20 tables containing all kind of setings for an application.
Al tables are like
(
TIP INTEGER,
NAME VARCHAR(100),
PRIMARY KEY (TIP)).

I want to merge all this tables in a single table wich contains the kind of
seting like:
( FL VARCHAR(30),
TIP INTEGER,
NAME VARCHAR(100),
PRIMARY KEY (FL, TIP)).

All this settings are made with TIB_LookupComboBox.
The problem is that in the Source table I have not a corresponding field for
the new field FL, so the KeyLinks contain only the TIP field. The result is
a 'Multiple rows in singleton select' error when I open the query. But after
that all works fine, until I close and reopen then query.
How can I avoid the error message ?
TIA
Dorin