AnsweredAssumed Answered

Compare Prices from Different Dates

Question asked by DanShaw on May 23, 2012
Latest reply on May 23, 2012 by philmodjunk


Compare Prices from Different Dates



I've read through the Filemaker Training Series and still can't grasp reporting and structuring tables.  Here's what I want to do and thanks in advance for any help.

I have a product, price and date and want to compare prices on different dates.  So apples are $5 on 1/1, $6 on 2/1 and $7 on 3/1.  How do I set up my table(s) and how can I get a report that allows me to choose "apple", "date 1" and "date 2" and will yield the 2 prices.