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.
"It hit an iceberg and it sank. Get over it."
Robert Ballard, dicoverer of the Titanic wreckage.