Can you tell us what the SQL for your query is? Does it just select all the
fields in the table that references the lookup? If so, you probably need to
do an explicit join with the lookup table, e.g. instead of

SELECT x.* FROM tablex x ?

try

SELECT x.*, y.* FROM tablex x INNER JOIN tabley y ON x.lookupIDfield =
y.lookupIDfield

or the old-fashioned way

SELECT x.*, y.* FROM tablex x, tabley y WHERE x.lookupIDfield =
y.lookupIDfield

I don't know if that wil fix the problem but it's probably what I would try
in the first instance.

Peter Jamieson