Is there a field to pull a locations last purchase price? If not I'd assume I have to do a sub query on the transaction table, and select the first record.

On item record from the location sublist.