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?
What end result are you looking for? Do you basically want a list of records that ever had a pricing change? Could you clarify the end result?
As for your question regarding posting sample data, this forum unfortunately unlike others does not provide a means to attach sample files. You would have to upload the file somewhere else and refer to the URL for it.