I am assuming we're talking SQL Server?

You can insert from a SQL Server view into the base tables, sure. Even if the new record does not match the view parameters. If you want to setup a situation where a record can't be added unless it meets the view paramters, use WITH CHECK OPTION when creating the view and non-matching inserts will be rejected.

Now if we're just talking VFP, forget all that and insert whatever you want into the view.


>If I insert a record into a SQL table, do I need to open the entire SQL table, or can I have a small view and then insert a record that would not fit in that view.
>
>I meanif I vae a view for phone number =123 and then I insert a new record n SQL for phone number 456. Do I need to open entire SQL database, or can I insert from that smaller view????
>
>THANKS
>Joel
>Houston, TX