Many a time I have referenced other threads as well. Just a rhetorical question, but how many referrals before it should be a FAQ? :)

>That's what I like about UT. You do 5 hours of work and write it up. I copy down the message # and get all the credit < eg >
>
>Barbara
>
>>You got that right! I blew about 5 hours trying to figure that one out. From now on I only use view designer to get first-cut SQL code. Then I cut and paste SQL into a .prg file, then modify the code to un-nest the joins. Then execute the code to create the final view.