Hi.
I have a table, "tblStaff" which lists every employee in our area.
I have a second table, "tblLocations" which lists the cost centre for each location, address etc.
At the moment, tblLocations has a field called "Responsible Manager", which is a lookup from tblStaff. This all works fine for inputting data.
HOWEVER
This appears to cause problem as every employee has a location as their base (which is a lookup in tblLocations).
What I want to be able to do is record when somebody worked their day off in a third table "tblRestDaysWorked". This shows who worked it (tblStaff:ID), what date it was and why.
The problem comes when I want to build a query based on that table. I can use the employee ID to find out the details but when I add in the "tblLocations" to find out their cost centre (to group the report by cost centre) it causes a problem, presumably because of the "Responsible Manager" field.
Any ideas?