I have 4.2Fn and received similar error. The solution was not to use
subselect in the list of required fields but join the lookup table:

not

SELECT a.Field,
b.TitleID,
(SELECT Title as The_Title
FROM Titles t WHERE t.TitleID = b.TitleID),
FROM (tables, joins)

but

SELECT a.Field,
b.TitleID,
t.Title as The_Title,
FROM (tables, joins + JOIN Titles t ON ....)

Ales Kahanek

-----Original Message-----
From: Hie Joen [mailto:hiejoen@...]
Sent: Monday, January 21, 2002 1:27 PM
To: IBObjects@yahoogroups.com
Subject: [IBO] Lookup list in IBO 4.2Fp


Dear List,

Can someone describe about the syntax/features (KeyLinks/KeyDescLinks)
in IBO 4.2Fp ? My lookup list isn't work anymore when I upgrade to 4.2Fp
from 4.2Fn.

The error is MainQuery.FIELD_NAME not found.

TIA
HJ