Thanks for the reply. Sounds like you have been in the trenches with FoxPro's indexes for a while. I do have indexes to make my views use Rushmore as you suggest. Each of my tables has an integer unique identifier that is also an index key. I've been trying out two different approaches to get the next unique identifer. One technique uses SELECT MAX(UID)... and the other uses a GO BOTTOM... Both approaches run slow across the network. Do you have a proven technique for quickly getting the next unique identifier?
Thanks,
John