Finding differences in related records?
I'm fairly new to the filemaker world, so please bear with me.
I've a Filemaker 10 Advanced database that tracks pricing changes over time. It basically has three fields that are pertinent to this question:
Once a month, we dump the pricing for all items and add the records to the database. So, a snippet of the database might look like so:
I'm hoping to pick out just the items that have differing prices. I feel like this is elementary, but I can't figure it out.
As an aside: is there a better way for me to post sample data?