Thanks for your help so far, I go to bed, in Germany it's now 4.00 in the morning.
I will try your suggestion tomorrow.

Guido.

> I understand therefore that you want to see 33 columns in the output. I
> think you have a major problem with the dynamic SQL statement because it
> seems impossible to identify the KeyLinks. I would want to get this
> dataset with a stored procedure that passes the first set's unique ID as an
> input parameter, and outputs each row into a set of uniquely named
> columns. (FOR SELECT....INTO...DO...SUSPEND).
>

But the number of columns is variable. How can I realize this with a SP?

>
> That way you can invoke it with a SELECT statement and bring it into your
> app cleanly as a distinct, refreshable, bi-directional dataset.
>
> Helen
>
> All for Open and Open for All
> InterBase Developer Initiative · http://www.interbase2000.org
> _______________________________________________________