>>Does putting the call to GenerateID() in the default value automaticaly add the new index value when you append a new record?
>
>Yes, and that's the cool thing. One caveat: views have their own default values, so if you add into a view (which I avoid), and you need the PK before TableUpdate, extract the defaults for the table from the DBC first.

Or specify the same default value in the view definition, and the view takes care of itself.