title: Foxpro Select Most Recent Order for Each Customer
body: <p>In a foxpro table, I have 4 fields: ordernum, orderdate, ordertotal, custpk.</p>
  
  <p>What is the foxpro select statement to return all of those fields from the most recent order for each custpk?</p>