General information
Category:
Forms & Form designer
>In order to make a view updateable there must be a primary key on the underlying table. This is required so that the original record can be found and updated by the TABLEUPDATE function. While your view may consist of fields drawn from multiple tables, you may only wish to update one table from the view. You do this by selecting only the fields that are made updateable. When it is time to update, you can issue a tableupdate command.
>
>In the update criteria tab, you mark the fields you want to make updateable, and also the fields that are part of the primary key of the underlying table.
Thanks Bob, that's the best explanation I've read anywhere ;). I'm going back to look at my views and see if I can get some key fields in there. How does this work when you're using other views as data sources? Are the keys the ones from the original tables that created the first views?
I guess I'm thinking you join Table1 and Table2 to make ViewA, then join ViewA and Table3 to make ViewB. Would the key fields be fields from the Tables?
Mandy
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only