Go Back   Access World Forums > Microsoft Access Discussion > Tables

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 04-26-2004, 05:35 AM   #1
ChampionDuy
Registered User
 
Join Date: Mar 2002
Location: Washington DC
Posts: 94
Thanks: 0
Thanked 0 Times in 0 Posts
ChampionDuy
Adding a request date field

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!

__________________
Brian Duy
ChampionDuy is offline   Reply With Quote
Old 04-26-2004, 05:39 AM   #2
Mile-O
Back once again...
 
Mile-O's Avatar
 
Join Date: Dec 2002
Location: Glasgow, UK
Posts: 11,312
Thanks: 4
Thanked 118 Times in 108 Posts
Mile-O will become famous soon enough
You'll find an Auotnumber to be a better primary key.
Mile-O is offline   Reply With Quote
Old 04-26-2004, 05:40 AM   #3
ChampionDuy
Registered User
 
Join Date: Mar 2002
Location: Washington DC
Posts: 94
Thanks: 0
Thanked 0 Times in 0 Posts
ChampionDuy
Quote:
Originally Posted by Mile-O-Phile
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.

__________________
Brian Duy
ChampionDuy is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump




All times are GMT -8. The time now is 08:34 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World