help with duplicate records

[bishop0071]

I have a form with Last Name and First Name field. I want it to where if a new record is created and the same first name and last name is entered the record will not save right away and will give you the option to go to that record or to save it.

 

[brixie11]

By the sound of your question this is not a very good idea. If you are setting the criteria only on first and last name what if there are realy two different persons with the same name and last name ( it is not that uncommon ). I would do the check on some more fields, like a birthday or something more unique.

 

[bishop0071]

That is fine. That is why I would like to have the option to either go to that duplicate record, or if it is not the same person to go ahead and save that record.