The FoxPro grid is just fine. If you move away from using tables directly and use views instead you will find that all of the issues you are wrestling with go away. You can use parameterized views and requery them anytime you want and the grid loses nothing in the process.
