If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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 |
Thread Tools | |
Display Modes | |
|
|