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

[Nick_Parsons]

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_KULACOGL]

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