Hi everyone,
I am quite new here and to Access; however, I do know having a good design plan is critical. This is what I need help with obviously. So I am trying to leave my database open to adding more functions if I need to later on.
So right now I am working on a DB to keep records of Biomedical preventative maintenance. It is critical that I can go back and see past inspections of a customers facility as well as when adding a new inspection I can just update readings from the last inspection to create a newer inspection aswell as add new equipment if needed..I'm not quite sure how to do this lol
So far I have these tables: Customers>PMs>Dates>Equipment
Is this the most efficient way to do this?
Blah, sorry I don't have anything in Access yet I'm doing it on paper and trying to get how everything will flow before I start tinkering in Access