I'm trying to create a database for a daily checklist on server health. I have the general thing all set up, but I'm trying to work on making it more efficient.
Basically, I have a date, server name, and certain aspects of health levels plus an action taken column.
What I need help with is setting it up, so that when I do a new day of entries, the entire server list is populated as well as the date, and everything else is manually filled out. The premise behind this is so that I can also get a report on a day previously entered so that the data can be verified.
I've been trying for a week to figure something out, but can't seem to get something working properly on that.
I currently have three tables. Servers (which just contains the names of the servers themselves) DailyCheck (which is all the information that gets populated) and Answers (which for the pulldown list for the health aspects is listed)
Any help would be greatly appreciated.
Basically, I have a date, server name, and certain aspects of health levels plus an action taken column.
What I need help with is setting it up, so that when I do a new day of entries, the entire server list is populated as well as the date, and everything else is manually filled out. The premise behind this is so that I can also get a report on a day previously entered so that the data can be verified.
I've been trying for a week to figure something out, but can't seem to get something working properly on that.
I currently have three tables. Servers (which just contains the names of the servers themselves) DailyCheck (which is all the information that gets populated) and Answers (which for the pulldown list for the health aspects is listed)
Any help would be greatly appreciated.