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