Binding Database to multiple controls
-
This was posted in the VB forum as well since I was not sure which it pertained to. Ok, not sure exactly how to word this so here goes. I have a winform in my project that has the following: Controls 1. DropDownList1 - Customer Name 2. TextBox1 - Customer ID 3. DropDownList2 - Site Name DataBase Tables 1. tblCust - Fields(CustName, CustID, Status) 2. tblCustSiteAssoc - Fields(CustId, CustSiteID) 3. tblCustSite - Fields(CustSiteID, CustSiteName, ...) What I am trying to do is this: 1. When the form open have customers names bound to the DropDownList1 control with nothing selected 2. Once I select something in the DropDownList1 control (SelectedIndexChanged) have it update the other two controls with the selected customers' data. I assume I make a DataSet that queries all three tables and I understand how to bind the CustName to the first DropDownList box. What I don't understand is how to use the selected information to get the relevant information for the other two controls. Thanks in advance, Taen Karth Thanks, Taen Karth