Hi,

Could someone tell me how to solve this problem.

I have two tables in the same database, customer and orders. They have a common field ( customer number). I am trying to set up a form to display the order(s) for any given customer. I have two datagridviews on my form, one for the customer table and one for orders. At present the datagridviews are showing the entire data from both tables. Ideally I like the top datagridview to show all the customers, and the bottom datagridview to show only the order enteries for the currently selected customer.

My question is how do I do this.

Kareem