I have standard solution with following scheme
COSTUMER/ costumer_ORDERS / costumer_orders_LINEITEM / costumer_order_lineitem_PRODUCT.
I have a portal showing all products from a client. I can do that by using records from the last TO (costumer_order_lineitem_PRODUCT). This is not a problem.
Instead of this I would like to have a portal showing:
Product Last purchase date (of the product) Last price (of the product)
To do this, I think I should use the data from (costumer_orders_LINEITEM). I guess I should filter the portal in order to show only the last LINEITEM record containing each product. Or perhaps there's another way to do. I guess this must a common request.
Can anybody help me on that?.
Thanks for your help.