I don't know why this is giving me so much trouble, seems pretty straight forward. I have two tables:
tblEmployees
EmpID
EmpName
tblArea
AreaID
AreaName
PrimaryContactID (fk to Employees table)
SecondaryContactID (fk to Employees table)
I just need a simple query to show the data like this:
AreaID
AreaName
PrimaryContactName
SecondaryContactName
Do I need to do some kind of Dlookup function or something? A sample would be WONDERFUL, thanks!
tblEmployees
EmpID
EmpName
tblArea
AreaID
AreaName
PrimaryContactID (fk to Employees table)
SecondaryContactID (fk to Employees table)
I just need a simple query to show the data like this:
AreaID
AreaName
PrimaryContactName
SecondaryContactName
Do I need to do some kind of Dlookup function or something? A sample would be WONDERFUL, thanks!