Hi!
Thanx, that worked!
Before posting the question I already tried this solution, but I used a
parametered query in the calcfields method to find the matching lookupvalue.
That resutelted in a messed up grid when scrolling and incorrect lookup
values.
But using the lookup function gets everything right.
Thanx!

Kjeld

> 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.
>