Table Relationship Issue

[excellenthelp]

Hello Accessers,

I am pondering on how to make this a possibility, knowing there is a way... I am just unable to come up with a method. Hope you can help.

I have created an Employee table with names, address, phones, etc. and another table (Report Track table) to track the report.

The dilemma:
How can it be possible to have three fields and join the tables? The three fields are: [Lead Auditor], [2nd Auditor], and [Report Date]. The Lead Auditor and 2nd Auditor would consist names from the same Employee table. I am unable to create two relationships between these two tables (Employee table and Report Track table). How can this be designed better?

Let me know. Thanks!

[amrut]

Can't you relate both the auditor fields in report table to the primary key of your employee table ? Avoid spaces in table names, field names. Use tblEmployee, LeadAuditor, SecondAuditor, ReportDate etc.

[excellenthelp]

By creating relational tables, it will do wonders.

Thank you, amrut!!!

Marking this as SOLVED.