>>How about writing a newkey() function that deals with this separately from the primary key<<

Sounds like a winner to me. I was making sure there wasn't already something there I was missing.

Thanks for the help.

Mel Cummings