Lil Dupree
New Member
- Joined
- Sep 5, 2003
- Messages
- 1
I'm trying to set up a DB to track 250+ daily data variables since the late 1890s.
Table 1 (actual data storage) has these fields: date, day of week, 6 holiday info fields for holidays in various countries (Holiday1, Holiday2, etc, y/n fields), and data variables 1 - 250+ (field name D1, D2... they're numeric fields, and hold stuff like the Dow's close, interest rates, etc.).
Table 2 (information on each data variable) contains the data variable (D1, etc. in a text field), the variable's actual name, which 1 of the 6 holiday fields apply to the variable, the first valid data date, and a few descriptive text fields.
How in Hades do I relate these two? Or do I need to re-think the table design? Any help would be very greatly appreciated!!
Table 1 (actual data storage) has these fields: date, day of week, 6 holiday info fields for holidays in various countries (Holiday1, Holiday2, etc, y/n fields), and data variables 1 - 250+ (field name D1, D2... they're numeric fields, and hold stuff like the Dow's close, interest rates, etc.).
Table 2 (information on each data variable) contains the data variable (D1, etc. in a text field), the variable's actual name, which 1 of the 6 holiday fields apply to the variable, the first valid data date, and a few descriptive text fields.
How in Hades do I relate these two? Or do I need to re-think the table design? Any help would be very greatly appreciated!!