I have a filemaker file that I use as my inquiry file.
Let's say I already have a John Smith in there who lives at 21 Beach Street.
In the thousands of entries I have in there, I'm obviously not going to remember if I create a duplicate entry - we keep all our inquires for 10 years I think. Anyways, as it is now, I go in and create a new entry, and nothing stops me from creating a 2nd, rd, fourth or even 5th identical entry! I don't want to spend time double checking each time I put in an inquiry either.... so here's what I'm wondering....
Is it possible to make it so that when I click new entry and type in the first and last name, that IF it is a duplicate, that something pops up to let me know and asks if I would like to replace, update, create new etc..