I'm sure someone has had to do this before but Im having trouble. I have a customer table and a state table, with the primary key of the state table added to the customer table (foreign key). When I load my two table into one dataset, I have various textbox's bound to customer data. Now, I want to bind a combobox to the state table, so when I navigate through the customers, the state changes in the combobox, but still has a list of all states.

Any help?