AnsweredAssumed Answered

Finding differences in related records?

Question asked by dataheist on Oct 16, 2009
Latest reply on Oct 16, 2009 by mrvodka

Title

Finding differences in related records?

Post

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:

 

Item Number

Timestamp

Price

 

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:

 

Item|Timestamp|Price

12345|06/04/2009 12:01:02|1.99

12345|07/10/2009 22:33:33|1.99

12345|08/06/2009 10:05:12|1.99 

65432|06/04/2009 12:01:02|2.50

65432|07/10/2009 22:33:34|3.00

65432|08/06/2009 10:05:12|3.00 

 

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? 

Outcomes