title: create a listbox that combines data from two tables for a report
body: <p>In Microsoft Access, I am trying to create a report by combining data from two tables in to a listbox:</p>
  
  <p>Table One Holds the ISBN (which is like the bookID):</p>
  
  <p>tbl_StudentOrderLine:</p>
  
  <pre><code>   ISBN  Qty  Price  StudentPurchaseID
      1224  1    6         12
  </code></pre>
  
  <p>tbl_Books:</p>
  
  <pre><code>ISBN  BookTitle  Author
  1224    Random   Someone
  </code></pre>
  
  <p>I would like to produce listbox to show the details for each book where the ISBN matches the ISBN  in the tbl_StudentOrderLine and the only ISBNs shown are the ones with StudentPurchaseID = 12</p>
  
  <p>It doesn't have to be a listbox to show the results, any ideas will be helpful</p>
  
  <p>I have tried a UNION ALL and Have tried creating multiple listboxes but nothing seems to work so any help is much appreciated!!</p>