At 12:25 PM 22/08/2005 +0000, you wrote:

>Thank you Helen for a reply.
>
> > So the first thing to do will be to
> > remove that TIBOTransaction and just go with the internal
> > DefaultTransaction that is embedded in the IBODatabase.
>
>Interesting idea, but nothin's changed.
>
>I'll try to describe it again:
>Have manually defined lookup field on TIBOQuery:
>
>object IBOQueryDEPARTMENTNAME: TStringField
> FieldKind = fkLookup
> FieldName = 'DEPARTMENT'
> LookupDataSet = IBOTable
> LookupKeyFields = 'ID'
> LookupResultField = 'NAME'
> KeyFields = 'ID_DEPARTMENT'
> Lookup = True
>end
>
>If i'll make a select with query, it will correctly return department
>name based on: department id stored in a query and relational id in
>open table, resulting the name of department.
>
>If i'll make an edit of ID_DEPARTMENT in the query, than post and
>commit, it will reflect changes: ID_DEPARTMENT-OK, but lookup field
>returns empty string (related table is still open).
>
>Tried to call some "RefreshLookupList" method of the field, but no
>success.
>
>Thank you for any hint.

Try this:

File : /Demo Apps/TIBO-lookup.zip
Uploaded by : helebor <helebor@...>
Description : Demo of TIBO Lookups and Use of an Extra IBOTransaction

You can access the file at the URL:
http://groups.yahoo.com/group/IBObjects/files/Demo%20Apps/TIBO-lookup.zip

Helen