2 Replies Latest reply on Mar 12, 2012 2:16 PM by shona1

    Sorting in Portals

    shona1

      Title

      Sorting in Portals

      Post

      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
      CustomersOrFamily----<RentalCard----<RentalLineEntry>----RentalItems
      RentalLineEntry>...RENTALCARD2ForRentalDate