EnteredBy and InspectedBy

[Christopher Glaeser]

I have two tables: tblEmployee and tblInpsectionRequest. Included in the
Inspection Request are fields for two employees, the one who entered the
request and the one who did the inspection. Can I have two one-to-many
links from tblEmployees to tblInspectionRequest? I probably did it wrong,
but when I attempted to add the second relationship, Access created a new
table named tblEmployees-1.

tblEmployees
EmployeeID
Name
Phone

tblInspectionRequest
Date
InspectionAddress
EnteredBy (an employee)
InspectedBy (an employee)

Suggestions will be greatly appreciated.

Best,
Christopher

 

[Andrew Smith]

You've done it right. Access doesn't create a new table - the extra one is
just an alias of the original table.

 

[Christopher Glaeser]

You've done it right. Access doesn't create a new table - the extra one is

just an alias of the original table.

Thanks!!!