Hi people, I can't figure out how to solve this issue:

I have 2 fields: LastName and FirstName... what I want to do is that when I finish writing the name, FM warns me if there is another person with that full name. I mean, how I set the validation settings??

Example: I have 3 clients (John Peterson, Michael Samuelson, Sean Targus)... If I create another record with the LastName "Peterson" and the FirstName "John", I want to FM tell me that there is also another guy called John Peterson.

THANKS FOR YOUR HELP PEOPLE! YOU'RE THE BEST!

I wouldn't try to avoid duplicate data entry this way. How about preceding your New Contact routine with a Find/Select? If not Found, then offer the user the ability to create New.

Hi Bcooney, thanks for answering... but with "Find/Select" you're talking about a script? mmm i'm pretty new with FM, maybe you could show me and example of that "New REcord Routine"?

Thanks a really lot!

I've read back through your others posts and I am a bit concerned. I can guarantee you that, at some time, you will have two legitimate Bill Smiths in your database. Then what? Please just assure me that you are using unique IDs for the Customer table and not trying to maintain unique NAMES from which to base your relationships.

This is a quick and dirty demo.

FindSelectDemo.fp7.zip