John,
>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?
You really should be getting the next unique identifier from another table designed for holding the next id's for each table.
Your current approach *will* eventually fail and cause duplicate id's if you are running in a multi-user situation.