unique value, multiple fields
how to define 3 fields as one unique value in the table ?,
In the same field options dialog, there's a check box that allows users to override validation warnings. Clear this check box and the "yes" option won't appear.
"cuz the calculation type does not give u the option to define it as unique"
... but a text field, with optional auto-enter a calculated value, has that possibility.
but that option is not calculated instantly !! , my table has 10000 records already, and the option ur talkin about is only calculated when the record is modified, and i dont have the time or the desire to modify the 10000 records to display the calculated value.
Of course that solution will work for every new record.If you think to have dupes just now, first you have to isolate those records and correct them.
the solution u gived will only work for every new record but not for the existant ones, i need a better solution cuz the existant record are more than 10.000 records, and i dont wanna do it manually cuz its gonna take a lotta time, i can't figure why FileMaker Inc didn't think about this problem, i understant that Calcution type is not indexed so u cant put it as unique or on a joint, but there musta be a solution for this.
It isn't so difficult to isolate the dupes.
1) Create a calculation field with calc:Field1 & " " Field2 & " " Field3
2) Enter Find Mode
3) Put the symbol ! into that field
4) Press return
5) Sort by that new field
FileMaker will show you all the duplicate records but now you'll have to evaluate wich record keep and wich discard.
its not about duplicated records ,
my table have ( id_project, month, year, .... )
i want records to be unique, means :
id_project = 12
month = 4
yaer = 2011
is unique in the table.
if u wanna create another record with id_project = 12, month = 4 and year = 2011, fileMaker shouldn't accept it, THAT'S THE IDEA !!!
so the combination "id_project, month, year" must be unique.
I just worked on a project last night where the name, street address and city fields had to form unique combination. I used the same method that Raybaudi is suggesting and it works just fine to prevent the creation of duplicates.
i believe that Raybaidi suggestion allow the deleting of duplicated records, no!, what i want is to prevent the duplication in the future too,
if the method if Raubaudi does that , PLZ a litle bit of explanation cuz i didn't get it :)), is it a script or just a calculation ?
He made another suggestion first.
Define a text field as an auto-entered calculation:
Id_Project & " " & month & " " & Year
clear the do not replace existing values option.
Specify Unique Values for this field on the Validation tab.
but this one works only on new records, does not work on existing ones !!
Use replace field contents with this same calculation to update the field for all existing records.
one more think :)), when adding a duplicated record, filemaker show a custom box with 'revert' or 'yes', when clicking on 'yes' the record is accepted do u know how to fix this :))
thanks man, ur a genious !!! after finishing all the steps, it seams easy to make kinda staff but i think i'm just too tired to figured it out :p
thanks again PHIL ur awesome .
Retrieving data ...