Does anyone have a program or method that handles the assignment of primary keys for the many tables I have in my application. I want to avoid:

openign records already in use
using numbers that have already been assigned