I have a lookup table with and ID field and a Description field, and another
table that has its own ID field, the ID field from the lookup table, and
other data.
LookupTable
LookupTable.ID
LookupTable.Description
OtherDataTable
OtherDataTable.ID
OtherDataTable.LookupTableID
OtherDataTable.OtherData
There are stored procedures for SELECT, INSERT, UPDATE, and DELETE that
maniuplate data in the OtherDataTable as well as another set of stored
procedures for the LookupTable.
I need to create a form that shows the details of the OtherDataTable. To
that end I've created a DataSet that contains a DataTable based on the SELECT
stored procedure for the OtherDataTable the DataTable's INSERT, UPDATE, and
DELETE commands have been set to the stored procedures and I can call them
from my code. In the details of the form I would like to use a combo box
that will allow the use to make a selection based upon the list from
LookupTable where the selected item is LookupTable.Description and the
slected value is LookupTable.ID and the LookupTable.ID value is stored in
OtherDataTable.LookupTableID. Of course as the user scrolls through the
OtherDataTable the combo box must display the appropreate selection.