At 01:33 PM 3/06/2003 +0300, you wrote:

>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 ?

What is the SQL statement you are using?

Helen