>So - how the heck do I do this? Specifically - how can I "force" tableupdate to use the current value in my key field in its where statement? Please don't tell me I need to write my own "tableupdate". I thought @@identity was the answer to getting around having to have a "keys table", but I'm beginning to wonder.
>
>Any help is GREATLY appreciated.

Ken,

I am curious...

1. What is GETFLDSTATE(-1) of the record after you replace the ID field in the view with the PK value?

2. What is the record number?

3. What is the WHERE type of your view?

BOb