Maybe, what I think you will need to do is use a CalculatedFields entry and
then use a Lookup() call in another dataset to supply the values. This will
be slightly slower but it should be well within acceptable range because
calculated fields are buffered and rather efficient about only recalcing
when necessary.

Let us know how it goes for you.

PS. Be sure to use the ARow.ByName() and not FieldByName() in the OnCalc
event.

HTH,
Jason Wharton
CPS - Mesa AZ
http://www.ibobjects.com

----- Original Message -----
From: "Kjeld Loozen" <kjeld@...>
To: <IBObjects@egroups.com>
Sent: Friday, January 12, 2001 9:45 AM
Subject: [IBO] lookupvalues in ib_grid


> Hi all,
>
> I want to display lookupfield in a grid.
> I understand the examples in the getting started guide, but my problem is
> that the lookuptable is not in the same database as the mastertable.
> So, I cant create a inline select in the master-sql to get the
lookupvalue.
>
> I created a ib_query for the lookup, set up the keysource, and keylinks
> entries.
> Displaying this lookupvalue in a one-record-per-form manner is no problem.
> But i need to display the lookupvalues in a grid together with the related
> masterrecords
>
> Can this be done?
>
> Regards,
>
> Kjeld
>
>
>
>
>