Last TripSub of Invoice (MAX function)

[lineamovil]

Hello!

Im trying to find a way to show this info in a Query.

I have 3 BOs
BO Invoice
BO Trip
BO TripSub

Im Insert an Invoice record into a TripSub. Everything its fine. Its related, and I can see in Invoice how many times it has been related to diferent TripSub.

I want a Query to show all the Invoices and the last TripSub where it was related to.

I can show a query with 1 Invoice and its last TripSub, but not ALL the Invoices and their last TripSub.

Hope you can help me out with this one.

Thank you!!