tblDataRef
ID         Name
100        Accounting
101        Finance
102        Marketing
110        Supervisor
111        Shift Supervisor
112        Manager
113        VP

IDClient       Dept        Position       Salary
177            101         112            100,000
454            102         113            350,000

Select * from TblClientData where clientID = 177