Hello Filemaker (awesome) community,
i've read a lot of topic in this forum about finding duplicates values and i merely found a way to import unique data (using a processing table and a search function).
Right now i need to be able to find if a record (a website) is already in my database and flag it if it is the case.
My idea would be to have a function that does this :
- get the field i want to check for duplicate and put it into a variable
- open a new window and do a search of this term (though variable) in the database
- If result is >0 then i have a duplicate
- Otherwise it is a new record
Do you think it is smart ? is there an easier way for this check ?
Many Thanks for your help !