Help

Last Time a Product Type Was Ordered

Solved
Jump to Solution
1607 10
cancel
Showing results for 
Search instead for 
Did you mean: 
Ben_H
6 - Interface Innovator
6 - Interface Innovator

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

10 Replies 10

Elegant Solution Justin. Thank you. It even looks great in the gallery format. Thanks to Mo also.

BH