AnsweredAssumed Answered

Find and export records - only the highest value in a category

Question asked by BrianClark on May 22, 2014
Latest reply on May 22, 2014 by BrianClark

Title

Find and export records - only the highest value in a category

Post

     Hi folks,

     As a relative newcomer to FMP, I am trying to export some records and am having difficulty.....

     2 of the tables in my database are:

     MANUFACTURER [mName, contact email, contact name]  (approx 50 records)

     PRODUCT [pID, pName, description, price, mName]  (approx 300 records)

     So, a manufacturer makes many products.....

     I want to export each manufacturers most expensive product, but only the top 10.

     This is probably quite straight forward, but I just cant quite get my head around it!  Any help appreciated.  I am using FMP 12

      

     Many thanks

      

     Brian

      

Outcomes