I'm not outside of the database. It's open because the table is open.

>How do you call a stored procedure outside of the database?
>

Right. All the records have ids eventually. Except when I screw up *g*. Since I use surrogate keys, I don't usually care about them. The ID gets generated when the _table_ is updated. When I'm connecting parent and child records I call the id function in the insert because the buffered table won't have a value otherwise. (I'm mostly not using views.)
>Why wouldn't you need to insert an ID? I can't envision a situation where I'd want some of my records to have IDs and some not...
>

Since you're using a grid, I'm guessing you use table buffering...optimistic or pessimistic, right? Are you keys surrogate (sorry if I missed that part).
>I don't get this problem if I insert directly to the table, not the view, but then the grid isn't focused on the right spot, so that won't work. I guess I'll have to try and do an insert into.


Hope I'm not confusing you :-)