I have a table named eBay_Auction_Fees with the following fields: Fee_Amount, Fee_Name, ID_Auction.

There are times when we post an auction to eBay through FileMaker and it gets double posted (I have yet to figure out why). Because of this I need a way that I can quickly find duplicates.

Any time an auction gets posted twice, duplicate fee data is inserted into the eBay_Auction_Fees table for that auction record. So if an auction was charged a Listing Fee of 1.00 and a gallery fee of .35, I end up with 4 records in the fees table: 2 for the Listing Fee and 2 for the Gallery Fee. Of course all 4 have the same ID_Auction value which is how the relationship is made.

I need to create a script that will display auction records that contain duplicate fees. Any given auction record should only have 1 related record in eBay_Auction_Fees for each Fee_Name. I need to find the ones that have more than 1 record with the same fee name for the auction.

Does that make sense or have I rambled and confused you? Any information I can get on how to set this up in FM would be greatly appreciated. thanks!

You have indeed rambled and confused me.

PL give more info about your file and how your data will imported. I understood you have more than one table in your file??? How do you defined your relations …

This topic has come up in the past.

I just did a search for [color:blue]+duplicate +Record +flag +script and got 14 hits (you will get more if you modifiy this to just your key words).

There is a file by BobWeaver in this post Link that uses a process that I have used for many years.

You can add any number of Fields to the duplicate calc, in your case I would use the fee, the amount, the product name (and maybe more), to help eliminate those items that may be close.

HTH

Le

You could define a calculation field that concatenates ID_Auction & Fee_Name. Then search for duplicates in this field.

There are several other options to remove duplicate records, that you can find by searching these forums.