>Hi Naomi
>
>>The same idea as before - have an inner select to only get necessary info with group by and then join with the rest of the fields + all UDFs you need. In VFP9 you can do it in one select as I showed a quick sample thread reference (and AFAIK Sergey did too). In previous versions you would have to do it two steps, I think.
>
>Well it worked (Sergey and your response combined) at design time and broke royally at runtime.
Show your final select.
Are you sure VFP9 run-time settings are the same as in IDE (SET ANSI, SET DELETED, SET EXACT, SET ENGINEBEHAVIOR, etc.) ?
If it's not broken, fix it until it is.
My Blog