It is true that you can't have the whole functionality with views as you have with direct tables (well, not at the same performance anyway)

but then if you are considering moving to c/s you'd have the exact same
problems and the practives you have with views are the ones you need for c/s

depending on your system you may be able to keep some non-frequently changing tables on the local machines and still have lookup tables etc.
but then you have other issues like syncronization

Arnon

>We are trying to use views for all our tables because we want to have all our apps more prepared for a possible migratio to a client/server environment. Unfortunately we encountered that with view you loose some possibilities you have with working direct on the VFP tables.
>We now are doubting and considering to go back to working direct on the VFP tables. Can anybody cast some light on our discussion.
>Should we learn more about views and should we be able to do everything with them ? Is it indeed easier to work direct on the VFP tables ?, what is better ?
>
>Koos Veel