AnsweredAssumed Answered

How can I compare 2 tables?

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


How can I compare 2 tables?


     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"?