I guess you're missing a little with how views work.

You have to indicate the key field in the view designer. That's because once you send the view back to the Server, a record will be updated if the same key exists, added if the key is not there.

Pf

>I was thinking I had to have the entire table in order to insert a record. If I had a narrow scope view, I thought I could NOT insert a record that did not match that view.
>
>Question:
>If I have a view that returns NO records, can I still insert into the SQL table?
>
>I mean for example a view with all phone numbers that match 1234567890 and it does not find one in the sql table. Can I insert a record with phone number 987654321 ?????