title: LightSwitch - displaying related table information on Create screen
body: <p>I have <code>Table1</code> linked to <code>Table2</code> with a <code>1 to 0..1</code> relationship. <code>Table2</code> is read only, from another data source.</p>
  
  <p>When <code>Field1</code> (which defines a key to <code>Table2</code>) is entered in an entry screen, I would like to have the <code>Table2</code> data on the screen show the results that match <code>Field1</code>.</p>
  
  <p>For Example:<br>
  <code>Table1</code> is "WidgetProblem"<br>
  <code>Table2</code> is "Widget"</p>
  
  <p>When the user enters the Widget ID in the Widget Problem screen, I want the details of the widget to show up on the screen, without first having to save and then edit / display the screen.  I want the user to see the Widget information so that they can be sure they've got the correct widget.</p>
  
  <p>The fields are all there, I just can't quite figure out how to trigger the data lookup "early".  Back in the day I would just handle this on an event from the field, kick off a quick populate of the fields on the screen and be done.  Obviously it's not the same in LightSwitch.  Can anyone point me in the right direction?</p>