I have 4 tables (below). Needing help with the relationships.
tblGXPS6S -- (PK) ID, Emp_ID, EnteredDate, Area_ID, Ques1.....Ques25
tblAreas --(PK) Area_ID, Areas, Emp_ID
tblEmployees -- (PK) Emp_ID, FirstNames, LastNames, CurEmp
tblGXPSRms -- (PK) Rm_ID, RmNum, Area_ID
Each employee has to answer a 25 questionnaire weekly for their areas. Some employees have multiple areas but each area only has one employee. The areas can have multiple room numbers in them and some large rooms can have multiple areas in them. I don't know how to relate the areas to the rooms so that I don't have multiple Area_ID for one area for tblGXPS6S. Could someone help me with this and explain in English how to take care of my relationships properly.
Thank you for your time and knowledge,
Walker