AnsweredAssumed Answered

Sorting in Portals

Question asked by shona1 on Mar 11, 2012
Latest reply on Mar 12, 2012 by shona1


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