Subject | Re: Lookup field problem |
---|---|
Author | willy_metra |
Post date | 2005-08-22T09:16:56Z |
> *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*Sure, it's on query:
> components(s)? Which properties?
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 ahaystack"?
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.