Hi all I hope you can help or put me in the right direction.
I have 4 tables
Dept_ID int PK,
Dept_ID int PK
Dept_Group_ ID int PK
Dept_Group_ID Int PK
Position_ID Int PK
Employee: (Lots of columns but these are the only 2 relevant)
Each employee has a dept ID and a position ID.
The employee.Dept ID FK to Depts.Dept_ID.
Depts_To_Dept.Dept_id FK to DEPTS.Dept_ID
Now I am trying to get the Position_ID from employee and Dept_Group_ID from Dept_To_Dept to join to Dept_ID and Position_ID in Position table but can't get it to work as Dept_Group_ID is not unique or Position_ID is not unique but they are unique together.
I know this might not make sense so please ask any questions you want so I can try an clarify.
Thanks in advance