Hi! I was hoping I could find some suggestions for a
problem that I was having. I have a unique ID field in my
database but I want to be able to leave it blank for a
while and then enter a value into it later. Basically I
have a list of people in my database that are authorized
to do a specific task and therefore they already have an
existing id number. Then I have a list of people that do
not have an ID number and they are not going to receive
one right away until they have completed other
requirements, but I want to be able to put their personal
information into the database. So the only way to
distinguish the active people from the none active ones is
by whether they have ID numbers or not. This did not work
in Access because you cannot leave a primary key field
empty. The ID field that I created is a text field. Is
there anyway that I can have Access fill in the nonactive
ID's with a temporary number that can be changed later?  
Any other suggestions on what I can do with this would be
great!!! Thanks!