I have tables “customers” “orders” and “products”
Products has a multiple choice for product type.
Orders is linked to the customer and the product with a date.
I am looking for a solution to find the last time a product was ordered by a client in an overview/ filter/ group.
Example:
Product Type A
“customer” “product name” “order id” “order date”
“customer” “product name” “order id” “order date”
Product Type B
“customer” “product name” “order id” “order date”
I would love to hear some ideas or if you know anywhere else in the form where it is discussed.
Thanks in advance
BH
