title: How to bind a vb.net ComboBox to related tables
body: <p>I am developing a Windows Form Application against a SQL Server relational database.  An example of the database schema is:</p>
  
  <pre><code>TableA
  ------------------
  PK  A_ID    uniqueidentifier
      A_NAME  varchar(254)
  
  TableB
  ------------------
  PK  B_ID    uniqueidentifier
  FK  A_ID    uniqueidentifier
      B_NAME  varchar(254)
  
  TableC
  ------------------
  PK  C_ID    uniqueidentifier
  FK  A_ID    uniqueidentifier
      C_NAME  varchar(254)
  </code></pre>
  
  <p>In the form I have a ComboBox (<code>cboA_ID</code>) to select the <code>TableA</code> record (DataSource = TableA, DisplayMember = A_NAME, ValueMember = A_ID) and a TabControl where controls on each tab are bound to fields in either <code>TableB</code> or <code>TableC</code>.</p>
  
  <p>My question is, is it possible to bind <code>cboA_ID</code> to <code>TableB.A_ID</code> and <code>TableC.A_ID</code>?</p>
  
  <p>This is my first database application so if there is a better way to do this I'm all ears.  I have set everything up using the wizards in Visual Studio 2010, so I'm still not 100% familiar with what all the various TableAdapters and DataSets do.</p>
  
  <p>Thanks for the help.</p>