Please describe your design in more detail. Would those two fields with the duplicate company name be the same field in two different records or two fields in the same record?
The two fields are in two different records. I would want them both flagged up so I could remove the one I want, and then the remaining record would become unflagged as there would be no duplication.
The simplest way to trap for duplicate values is to go to field options and specify unique values on the validation tab. This will not, however find and display the matching record.
You could, however, use the OnObjectValidate trigger to run a script that checks for duplicates and performs a find to show the record with the matching value.
A self join relationship where this field is the match field can be used to check for records with a matching value.
I understand that 'unique values' would just not permit the second record to be created.
I'd like to create a new field that would look at the information held the the company field in its record and compare it to all the other company fields in the other records. If it finds a duplicate or more it would respond with a message, otherwise stay blank - a kind of if/else equation.
Then, when the duplicate(s) have been deleted and there is only one left the message would disappear - I could search for duplicates visually or by 'not blank' command.
You don't need a new field to do that. Just a self join that matches by the Company field.
YourTable::Company = YourTable 2::Company
you can use:
Count ( YourTable 2::Company ) to check for duplicate values
attached copy of file with duplicate files.
how does the YourTable work?
i thinks that's a bit advanced for me!!
You cannot upload FileMaker files directly to this forum. But you can upload the file to a sharing site such as "drop box" and then post the download link here.
But "YourTable" is just my placeholder for the name of your table. You would open Manage | Database | relationships, find the box for your table of data, select it and then click the duplicate button (two green plus signs) to make a duplicate Tutorial: What are Table Occurrences?. Then you drag to connect fields to set up your relationship.