tblEmployees:
empID (identity field)
empName
empActive
emp_dpID – foreign key to tblDepartments
tblDepartments:
dpID
dpName
tblEmployees:
empID (identity field)
empName
empActive
emp_dpID – foreign key to tblDepartments
tblDepartments:
dpID
dpName