Sorting in Portals
I have created Database for rentals. The rental Card has a portal in it "RentalLineEntry" to track the all items rented. On the Customers layout and the RentalItems layout I have another portal for related records from "Rental Line Entry" which is bringing through each related rental record. I have a RentalDate field also in these portals which is the date from the "Rental Card", Rentals are not always entered in order so I would like both portals to sort by Date Order with the last rental at the top, but as the Portal is not actually based on the Rental Card I cannot select it to sort from. Is there a way to achieve this.
I am using FM Pro 11. The Relationships/Tables are