I have created 5 tables as shown below
tbl_Employees
EmployeeId* - Number
EmployeeName - Text
tbl_EmployeeDetails
ID* AutoNumber
EmployeeId - Number
Designation_At_Joining - Text 'with combo options "Process Associate";"Sr. Process Associate";"SME";"Team Leader";"Dep Manager";"Assitant...