Define a relationship between an occurrence of table 1 and 2 like this:
Table2:SelectedProduct = Table1::Product
In Table2, when you select "Apple" in the Selected Product field, this relationship matches to all records in Table1 where Product = Apple. And then a calculation field in table 2 defined as Max ( Table1::price ) will return the maximum price paid for an apple.
You can also replace SelectedProduct with a calculation field, constApple defined to always have the value "Apple" and now your calculation returns the max price for apples, only and always apples.
The relationship can include a second match field if you want the max price for a specific store.
But note that this only returns the maximum price for the specified product. Other means would need to be used to access other informaiton in the same record as that Max price--such as the name of the store.
Thanks very much, that works great.