title: Access Joined Table Latest Record
body: <p>i have this database schema as shown in the attached image, I need to somehow join <code>tblDdiNumbers</code> with <code>tblTransactions</code> showing only the latest record from <code>tblTransactions</code> and no duplicated ddi_numbers. </p>
  
  <p>basically what i am trying to do is display allocated and unallocated ddi_numbers based on the information in the transaction table.</p>
  
  <p>so if ddi_number X has an entry in the transaction table i can determine that it has been used and is no longer free.</p>
  
  <p>or do you think it is maybe better to hold foreign keys of the information i want in the <code>tblDdiNumber</code> table instead?</p>
  
  <p><img src="https://i.stack.imgur.com/csu3y.jpg" alt="enter image description here"></p>