Hi Terry
>Just my opinion. You're using VFP. VFP is xBase. The fastest pointer set in the world. Those "relation" macro engines are sluggish. Analysts use them (and a lot of business analysts do use VFP), but programmers bent on writing fast crisp apps might do better to develop solutions using SEEK and other reiterative features to get the best performance.
You seem to constantly discount using SQL and that's a mistake. 5 pages of xBase code to do what one SQL can do opens the door to huge error margins. I've taken processes that took 8 hours and even 2 days and got them down to 15 minutes just by using a couple of SQLs and then some SCATTER/GATHERS.
My point is use the best combination for the specific task and keep this in mind as you do it:
http://www.joelonsoftware.com/articles/LeakyAbstractions.html