Returning only the latest record in a one-to-many query. I have two tables, one called Prop the other called PropPerm. The PropPerm table holds permanent data about a property and the Prop table...