Good day;
Doing a time line DB, and I have over 1/4 Million main records each having a minimum of 5 dates, with some (depending on detail) going into 20’s of dates.
MS Access AutoNumber is a Long Integer without a sign giving about 8 Million numbers and therefore records per table. This would give an average of 32 event records per main item.
Being in the non null camp, doing a table of dates, for the common 5 events, and a table of Events / Dates for the rest feels wrong (Split data & nulls). Using just a Event table creates a very long table and a weak point (1 table many times longer than any other table, first out of range).
Thoughts ? Am I missing or got something wrong? Another way?
Date Event fields examples
Birth, Service start, Marriage, Service end, Death, Located at date, Campaign, Rank, Unit assigned, etc
Thanks for looking