There's some debate, but I think the majority are pro-view. It makes it easier to scale and it looks like you're looking at needing to scale from the start. Views are kind of quirky and get on my nerves at times, but if I do any custom development, I use them. I don't use them often because my main job is SBT which is still in the dark ages.

Michelle


>Michelle,
>Thank you for your help.
>
>Is it good practice to use views( local or remote ) instead of tables in a form?.
>I have a database in a server and users (about 150) will access it remotely through our wide area network. The table that they will be accessing is called "Sales.dbf".
>I was thinking that by using views the refresing will be faster at the remote locations since I will use a Select statement instead of SET FILTER against the table.
>
>Thanks,
>Sergio