AnsweredAssumed Answered

Deleting a record with a higher value.

Question asked by tarheelme on Dec 16, 2009
Latest reply on Dec 17, 2009 by tarheelme

Title

Deleting a record with a higher value.

Post

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?

Thanks,

 

Dangerous newbie

Tysdad

Outcomes