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.

Barbara
>
>Barbara,
>
>Just curious, how does this accounting program generate PK's.