title: Binding multiple tables to Winform
body: <p>I have a Winform that will display columns from 2 tables.
  The form will have a bindingnavigator.</p>
  
  <p>The primary table on the form is a "child" of the second table.</p>
  
  <p>I need the opposite of the usual Customer/Orders linkage 
  where I want to scroll thru the "orders" and automatically
  pull the "customer" info.</p>
  
  <p>There is one common column (ID) between the 2 tables. The ID
  column in the "orders" table is not unique but the ID column 
  in the "customer" table is.</p>
  
  <p>The primary key in the "orders" table is a composite of the ID 
  column and an order# column which is unique. </p>
  
  <p>I was also unable to create a foreign key relationship when
  choosing the ID columns in both tables.</p>
  
  <p>I get this error:
  "The columns in table 'orders' do not match an existing 
  primary key or UNIQUE constraint"</p>
  
  <p>What am I missing?</p>