>I have several tables that contains data for multiple projects. I am now creating local parameratized views based on project for an application I'm working on. What I'm wondering is if I want to make additions to a view and TABLEUPDATE its base table, do all fields, including key fields need to be marked as updatable?
>
>Also, any approaches/strategies to working with updatable views in a form would be greatly appreciated as well. This is my first app using views and I want to try and get it right before building anything. TIA

i usually mark all fields in any table i'm updating through the view (including the key fields). my (primary) key fields are built in stored procedures, but i've had problems if i don't include them. don't remember exactly what happened -- been a long time since i tried that.