>George,
>
>Thanks for the advice. I am at best a novice when it comes to foxpro (or any other programing language) and am learning from my many, many mistakes. I thought I had done a pretty good job of setting up the databases but the more I do with this program the more I see how wrong I was (the referenced table in particular).
>
>Thanks again for your advice,

Russell,

At one point or another all of us were "novices".