Torgny,

So you can have more than one datum for a given cauktid? How would VFP know which date to give you?

If you don't care which one it gives you, what is wrong with setting enginebehavior, and then setting it back after the query?

< UPDATE >
I jumped in late...I see you have your answer now...

>>>
>>>How to get this working in VFP8 without setting ENGINEBEHAVIOR TO 70 ?
>>>
>
>I tried that, but it gives me all distinct values of cauktid and datum together