You got it wrong Paul, you have to insert the new record in the view, not the table. To get your PK routine and default values, you need to copy the rules from the table into the view.

HTH

---

>what is the proper technique for adding rows to a view? say the view is a simple one that only has one updatable table.
>
>the tables in my app all have PK's. in each table definition, the default value for each PK is generated by a routine that increments a PK counter.
>
>i have tried adding to the base table and then adding the same row to the view by doing scatter on the table and then append blank and a gather on the view but when i issue tableupdate(), changes to the view columns after the initial add are not saved back to the table.
>
>it seems that i need to add to the base table first, including any default vaules for other attributes and then requery the view so that i can see the new row.