Find and export records - only the highest value in a category
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