Hi, I have a list of users (auditors) that wi...

(Nick Parsons) #1

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?

(Levent KULAÇOĞLU) #2

Make the Auditor table a ref table to Audits and Locations ref table to Audits also