Beth,
 
Awesome videos I gotta say! I've got a question - let's say the LastName field is related to a Foreign Table that has common last names the user can pick from via a combo box. How would you set that up? And also, if the user does not see the last name, how can he add it?
 
Thanks again for the great videos!

The way I handler that is very simple. Just bind the the foreign table to a table within the dataset that is managed by a parametized query. Just go to the table adapter that is associated with the table and add the query. Then set the query parameter to be the selected value within the combo box in the parent. Hope this makes sense. I do see a problem with your data structure though. Having a foreign key on something as generic as lastname can lead to an immediate problem. Unless your database is very small and you will not permit any customers with the same lastname.

Can I do the same in Vb 2008? and how do I do this, cause Ado properties and events are not the same, its changed!!