AnsweredAssumed Answered

How can I compare 2 tables?

Question asked by YiLim on Apr 13, 2014
Latest reply on Apr 14, 2014 by philmodjunk

Title

How can I compare 2 tables?

Post

     hi all,

      

     i am new to Filemaker and hope I can get some help here.

      

     I need to compare 2 price list. One from 2013 and another 2014. They have 99% the same products description and same catalogue numbers but different prices.

      

     How do I create a report to show 4 fields: "Catalogue number", "Product Description", "Price in 2013", Price in 2014", "Percentage change"?

      

     Thanks!!!

      

      

Outcomes