I have SharePoint list with EmployeeID, EmployeeLocation. And also have EmployeeName and EmployeeID in Sql Server Database. Now I need Show EmployeeName in SharePoint list along with EmployeeID, Employee Location based on EmployeeID.
I am trying with Data Source Connections and External Content Types in SharePoint Designer, but missing my way. Can anybody please explain step by step solution if possible.