>George, the tables I'm linking with use their own internal schema which contains the year, the office and several other items to form a unique code. NOT a good method overall, but as I said earlier about the triggers, I'm stuck with it.

Thanks for sharing Barbara. I'm always curious about how other systems handle PK generation.