Hi, I have a list of users (auditors) that will perform audits at set locations at a set frequency depending on the audit type.
I currently have these tables:
Auditors Locations Audits
What would be the best method of assigning an auditor to an audit?
User | Count |
---|---|
37 | |
31 | |
29 | |
22 | |
18 |