We have been writing in VFP for about 6 months now and are converting our existing business application from a dos dbms to VFP. We have not been using views yet. We have been running across situations where we have struggled with whether or not to use filters or setting up relations. Now we are wondering if we should be using Views.

Right now we are using optimistic table buffering on our tables with relations or filters so that we can use =tablerevert across the board. Can we simulate this with Views?

Are there any speed considerations we need to be aware of?

Basically we feel pretty comfortable with the VFP syntax but we feel very ignorant regarding the best way to handle data in forms (ie relations, filters or views).

Any direction or guidance would be greatly appreciated.

Thanks,
Paul Acton