>However, I have found that by using views to access the data I need from J:\DBFS\CLIENTS.DBF was faster that using SELECT * FROM CLIENTS...
>
>I never used views before and this seems to be the solution to go for this installation. Am I on the right track by using views?

You are basically designing a CS app here. I would say that views, in particular, parameterized views will be very effective. Also, is it possible in your situation to do some sort of download situation? i.e. if the data on the 'remote' source doesn't change much, you could take the time hit initially, and then utilize local tables after that.

Just some things to think about. You can also (s) see next months VFUG newsletter for an article about C/S development (which I'm currently working on) that may have some tips that could apply in your situation.

HTH,
Scot.