I have a VB.Net application with a DataGridView control.
The Data Source for my DataGridView is tblProviderLanguage.
I want to do the following:
1. Add a combo box to my DataGridView control that will display the LanguageDesc field from the tblLkLanguage table.
NOTE: Tables tblProviderLanguage is linked to tblLkLanguage via the LkLanguageID field in both tables.
2. I want to hide the LkLanguageID field in the DataGridView control
3. When the form loads the DataGridView should display the LanguageDesc values bound from the tblProviderLanguage table (based on the LkLanguaeID field).
When the user selects a different value from the combo box. That value should update table tblProvideLanguage via the LkLanguaID field.
I hope the above makes sense.
I have included an image below to hopefully make things a bit clearer.
Thank you very much in advance for your help.