I'm developing a replacement operational database for gathering plant performance both operational and environmental.
I'm having a problem getting the various tables to have the proper relationship so I can generate reports from them later.
Currently all data is entered through one form. They enter the date, the data for each boiler and then the electrical generation data.
The form then dumps the data in three tables. Each table has the hour and date of the data and the the data for the respective boiler or the generational data.
When I go to generate a report of monthly data, the relationship between the tables is tripping up Access. I tried making a relationship between the date and time of each table, but that hasn't worked so far.
How should I design the database to make work best? Thanks!