troubleshooting Question

Date Fields intable?

Avatar of pdvsa
pdvsaFlag for United States of America asked on
Microsoft Access
25 Comments4 Solutions530 ViewsLast Modified:
Experts,

I have a question. Is it better to have date fields in say tblProjects  or better to have a link to tblDates with a one to many?  

Example: (tblProjects)
fldBeginDate
fldEndDate
fldAwardDate
fldBidDueDate

==>you wouldnt want each of those fields in a table  as a separate field, correct?  It is too limiting and requires many separate fields in the tblProjects.  It is better to design a tblDates (ID,ProjID (fk), fldDateType) with a relationship to the tblProjects (on ProjID) and have fldDateType as a combo box with a row source qry and a NOT IN event (on the form) to add what a user types that is not in the list.

little difficult to explain without getting too wordy.  Let me know if this makes sense.  I am pretty sure I am correct on this but wanted some feedback from an expert.  

thanks...
Join the community to see this answer!
Join our exclusive community to see this answer & millions of others.
Unlock 4 Answers and 25 Comments.
Join the Community
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 4 Answers and 25 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros