Key and Description Values
Posted on 2008-06-23
Sorry if this question seems simple but I am struggling moving from VB6 to VB.NET 2008, but I will eventually get there.
I have a couple of grids that display data from access right now ms sql later. The data is from a query and not directly from 1 table. I allow the user to make changes to the data how can I update the actual tables.
One table has key values only and the other tables have the key values and names.
So I allow the user with a combo box to select the names in the grid and I now want to write back to the database the key values.
For an example I will use vehicles.
Table1 contains key values only
I then have supporting tables for Color, Make, and Model that contains Keys and descriptions.
Thanks for the help