I've been trying to code my grid to allow a user to choose a job to assign a list of materials to. There is a Material table which is bound to the data grid. It has a foreign key link to the Job table. I initially bound the Material.Job field but due to the fact that it has a foreign key constraint underneath in Linq2Sql, whenever the grid tried ...