Need some help with what should be a simple script...???

[angelleye]

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!

[AVD128]

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 …

[Lee Smith]

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

[comment]

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.