Table Joins into one Dataset Update(Only want to update 1 table)

See more:

VB

DataGridView

ODBC

dataset

, +

Hello,

I currently have a dataset which contains data from 4 separate tables. The reason the dataset contains data from the 4 tables is in order for the data to be more reader friendly i.e. I have a table which contains descriptions based off an I.D. and I have another table which just contains the I.D. so the join gets the description from the table that I do not want to update and inserts it into the dataset so the user can select the description and not have to care about the I.D. THe issue im running into is when attempting to update the dataset given the

adapter.SelectCommand = New OdbcCommand(query, conn)
        Dim builder As OdbcCommandBuilder = New OdbcCommandBuilder(adapter)

I am obviously getting an error stating that the datafields do not match i.e. the description isn't a number and therefore can't be entered as an I.D. Does anyone have any idea of how I could possibly tell the updater to reference the other table for the I.D. using the given description?