View Single Post
  #1  
Old December 2nd, 2009, 09:48 AM posted to microsoft.public.access.tablesdbdesign
DavidG
external usenet poster
 
Posts: 34
Default Use of a Date Field in Primary Key

Hi,
I'm building a database of horse racing information. One of the fields I'm
considering as a Key field is Date - RaceDate. One date has many races. Is
a Date field a wise choice as either a primary or part of a composite?

It seems to be a natural choice in this situation, but I've heard some
awkward stuff regarding the use of dates. Is this just hoodoo voodoo, or is
there any substance to an argument that advised against using dates?

Thanks
David G