Hello again;
Based on the answers of the last two question (Time/Date stamp Location & Handling nonspecific dates), the date field group has expanded to three fields for each table:
Recorded Date …. text type
Accuracy ….. number type
Working Date …..date type
Does it make sense for each date point to use all three fields in each table or to use a link pointing to that date?
Usually within the data, there are many dates that are identically and their accuracy is the same (in fact same source). I’m thinking since each date could change independently I should bite the bullet and handle them all as a group. This could become a real pain as I know a lot of dates are solidly linked (same official source), but not all. (25% of 000's of records still a lot)
Comments ?
Neil