Adding a request date field (1 Viewer)

[ChampionDuy]

I have a DB that is currently being used by a few users and they would like to add a request date field to some of the tables. Here is the probelm. The tables hold info on Drivers license's and SSN's and things like that and the Primary Key is the DL# or the SSN#. The user would like to keep track of when he or she requests the new DL # but at that time she will not have a DL# so I cant just save the Request date because you cant leave the Primary Key as Null Value. What is the best way to go about solving this problem. Do I need to create another table with the date linked to the original table? Thank you very much!

 

[Mile-O]

You'll find an Auotnumber to be a better primary key.

 

[ChampionDuy]

You'll find an Auotnumber to be a better primary key.

Thanks!! I will try that, I knew I was going about this the wrong way.