Thank you Michelle and Ed for your help.

Michelle, when I type in GETKEYNO('tablename') in the default value of the primary key... in place of where you typed in 'tablename', do I put the name of the table the primary key is in? It is that simple?

It seems a lot easier your way than the way than having to create a stored proceedure and a sysinfo table

Jason