While I do agree that INSERT statements using the view SHOULD fail (because I believe age is important in this context), it WON'T fail because the age column allows NULL...

My primary use for updateable views is for bulk inserts into tables with more columns than the source files have. The views' columns match the source files' columns. BULK INSERT...

Perhaps I am not understanding your need. What I am reading is that you make changes to your client records (without naming the table that contains the clients)  and that...

• This reply was modified 8 months, 1 week ago by  tmyers 75436.
• This reply was modified 8 months, 1 week ago by  tmyers 75436.