mutiple tables and data sets from access to be used in VB.net

[shummy1]

I have 6 different tables that need to be used in a windows application. The problems is:

I want to load the combo boxs for some of the fields but once every different box has data chosen I want it to update the dataset for its table as well as the dataset for the table where all completed records are.

A single record will contain information from each of these different tables but gets saved into its own records table.
I have been going around in cirlces with this one. Any direction would be nice.

 

[stravis]

I think the lack of response is due to the fact that I am not the only one who is confused. Please try restating your question with some hard examples. The concept of updating multiple tables is confusing. What are these tables related to? The combo box values?