Hi there!

I am busy developing a in house costing system. I am using datagrids in combination with datasets. My question is more a design issue than a programmatic one. I have a Employee table and a JobType table which has a M:1 relationship.

In the datagrid I want to display the Employee details and allow the users to add,delete and insert Employee's. And add,delete and insert JobTypes in the same datagrid.

The idea is to display the Employee details and replace the FK: JobTypeNo with a more descriptive field.

I am thinking along the lines of hiding the FK: JobTypeNo column in the grid and then inserting another column in the grid and bind a combobox to it.

My question is, would this be the best/fastest solution?