Deleting a record with a higher value.
Using FMP 9.0/ WinXp
I import pricing from manufacturers which include a regular price and a promotional price for the same product.
In my database I only need the highest price since I base retail pricing from it.
I can find duplicates and sort so the highest price lists first, but I'd like to delete the second record with the lower price.
How can I do this?