Carl,
I think Randy's point here is just to use a table to get your key value. You can still do this in a stored procedure. I would suggest also to use the key field's Default value setting to call the procedure, not the insert trigger.
Mark

>But that is such an application driven solution. I am looking for a database level solution, so that no matter how I add records, (form, append command, append from file, insert into command...) keys will be assigned.