2 Replies Latest reply on Nov 21, 2016 12:50 PM by emotionuk

    Filter by date - really simple problem

    emotionuk

      Hi guys,

       

      It's been a long time since I used FM and so I'm a bit rusty, but I think what I want to do is really easy!

       

      Basically, I have 3 tables: 'Products', 'Orders', and 'Order Items'. So, you make an order in the 'Orders' table, and add items from the 'Products' table to the 'Order Items' table.  The thing is, the customer wants to see totals of all items ordered within a date range. Now, I used a filtered portal to do this using a layout with the 'Products' table, but it's as slow AF.  Now, I believe that I can accomplish the same thing using a relationship, but I can't seem to wrap my head around how to do it.

       

      So, can anyone help me out? I will be eternally grateful.

       

      Christian