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.