Thanks for the advice. The client on this project wants to have an upscale potential for the future, so I am running VFP tables on the backend connected via odbc to the vfp frontend (gives them the ability to just define the tables and repoint the connection later). and I have been avoiding indexing the views because of the performance hit at startup. Being new to vfp (and having a tight deadline on this project) I havn't really had much time to look at the options on this. Again thanks and any further thoughts you have ... Jeff