Quick newbie question

[Proprius]

Hi,

In one of my files I have a First Name field and Last Name field. I've had a problem with users frequently creating duplicate records for people, so I'd like it to inform them when they've entered a first and last name combo that is not unique. I wrote a quick calc field (first_name & " " & last_name), but unlike with regular fields I can't find a way to have this data validated. I'm sure there's an easy way to do this but at the moment it eludes me.

Thanks!

[comment]

See if this helps:

http://www.fmforums.com/forum/showpost.php?post/204677/

[Mike Williamson]

Take your calc field and use it to drive a relationship. Call it 'Name by Self Join via Cac' or something like that. Then create a field that counts all records through that relationship. If count is 2 then display a large field "Duplicate"

Hope this helps

[Proprius]

Thank you comment, that works perfectly! Thanks again.