Subject Re: Lookup field problem
Author willy_metra
> *Which* components?
TIBODatabase, TIBOTransaction (with AutoCommit on),TIBOQuery (here
are the DEPARTMENT_IDs of every employee and lookup field defined to
the TIBOTable with DEPARTMENTS, resulting the name of the department)

QUERY.DEP_ID
TABLE.ID
TABLE.NAME

> In what way have you defined the lookup field. On *which*
> components(s)? Which properties?
Sure, it's on query:

object IBOQueryDEPARTMENTNAME: TStringField
FieldKind = fkLookup
FieldName = 'DEPARTMENT'
LookupDataSet = IBOTable
LookupKeyFields = 'ID'
LookupResultField = 'NAME'
KeyFields = 'ID_DEPARTMENT'
Lookup = True
end

> Have you heard of the expression "looking for a needle in a
haystack"?
Yeah i heard, i'm not a silly little boy. Just hoped my question is
frequently asked, newbie one as the most of the question asked here.