I have WPF DataGrid bound to an SQL server table, one of its columns is comboBox. I want to populate the comboBox from another table. For example: there are two tables - jobs and employees:
- employees has EmployeeID, EmployeeName, EmployeeJobID
- jobs has JobID, JobName
I want the comboBox in Employee DataGrid to display JobName from jobs table
How to do this?