Subject | RE: [IBO] FW: Updating a join (in a grid) |
---|---|
Author | Helen Borrie |
Post date | 2000-12-06T10:54:44Z |
At 09:19 PM 06-12-00 +1100, I wrote:
....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
_______________________________________________________
>Here is the SQL for the lookup dataset, let's call it qryT2:I should have said:
>
> 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
....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
_______________________________________________________