title: How to make a drop down list (list box)in an MS Acess Query with values from two different tables
body: <p><img src="https://lh5.ggpht.com/_1i05Jryazos/S0JxuolQgqI/AAAAAAAADcM/78uv1ZTzPMw/s800/screenshot.10.jpg" alt="TablePic"></p>
  
  <p>I need the drop down box above to display the date as shown and the ClassTypeDesc as you can see above the dropdown list shows 1/12/2010 twice. They have different ClassTypes Assigned to them. </p>
  
  <ol>The drop down list should show:<br>
  1/12/2010 ACLS-I Day One AM<br>
  1/12/2010 ACLS-I Day One PM</ol>
  
  <p><img src="https://lh4.ggpht.com/_1i05Jryazos/S0Jmnpqj_8I/AAAAAAAADcE/_v1W2f-H4W4/s800/screenshot.8.jpg" alt="RelationshipsPic"></p>
  
  <p>I need to know the statement to put in the Row Source Box on the lookup tab in the Field Properties to make this work.</p>
  
  <p>Related <a href="https://stackoverflow.com/questions/1504583/help-with-query-design-in-ms-access/1504697#1504697">Question</a> on Making a drop down list</p>