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!!
Last TripSub of Invoice (MAX function)
-
- Posts: 201
- Joined: Tue Jul 27, 2010 2:17 am
- Location: Mexico
Last TripSub of Invoice (MAX function)
LineaMovil // Carlos Castillo
AwareIM Version 8.6
Windows Server 2021
MySQL Database 8.4
MEXICO
AwareIM Version 8.6
Windows Server 2021
MySQL Database 8.4
MEXICO