1 Reply Latest reply on Oct 16, 2009 7:51 AM by mrvodka

    Finding differences in related records?

    dataheist

      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? 

        • 1. Re: Finding differences in related records?
          mrvodka
            

          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.