Hello all,
This is my first post on the forum and new to access so bare with me..
We are making a safety database at my company. It will track our audits and open safety issues. Our audits are basic check lists (pass/fail) that we would like to convert to forms and reports within access rather than doing them by hand with hard copies. We want to have forms and reports for each type of audit, have one master list of all audits where there were "fails", and have a master list of all audits where we can track them, give due dates, assign to people, etc.
I know I can make forms and reports for each audit but I'm not sure if this is the right way to do it. I feel like each type of audit should have its own table, query, form and report but i don't know how to then make a master list containing all audit types so we can look at the audits that have fails.
Any suggestions are advice on how to set this DB up?
Thanks