I have a database with a customer and orders table. I have a portal based on the customer layout that displays
the customers orders. The portal currently has 10 rows. I want to be able to just display the most recent 10 orders
the customer made based on the order creation date. I know I can sort the portal by the orders creation date, but that
will include all of the orders, although they may not be visible to the user. I want to just only include the latest
10 orders for the customer. I want to be able to do this via a relationship. Both of my tables have include the customer_ID
and a creation_date.
Is this possible?