At 09:19 PM 06-12-00 +1100, I wrote:

>Here is the SQL for the lookup dataset, let's call it qryT2:
>
> select id, Description from T2
>
>Add a TIB_Datasource for qryT2, let's call it dsT2.
>
>Now, in the fields editor for qryT2, set its KeyLinks as
> id=T1.id2

I should have said:

....set its KeyLinks as

T2.id=T1.id2

You need both table identifiers. Sorry !

And I should have mentioned that you need to set the Visible property of
the id2 in the main table and id in the lookup table to false, but you
probably already worked that out.

H.
All for Open and Open for All
InterBase Developer Initiative · http://www.interbase2000.org
_______________________________________________________