Check Field To See If Duplicate Already Exists

    I have a database that keeps track of information off of a ticket.
    Each Ticket has the Ticket # at the top of it. This # is also the key. Sometimes I will get a duplicate and I dont know it until I have typed in the entire ticket and clicked "New Record".
    Is there a validation or something that if I enter in a Ticket # that already exists, it will flag me? I was hoping a Validation rule or in the Macro Builer. I dont have experience with code.
    Thanks
    Jason

    Re: Check Field To See If Duplicate Already Exists


    I get a warning when I hit "New Record". But that doesnt happen until I have typed in 25 fields. I need a check right after I enter the Ticket #.[hr]*[/hr] Auto Merged Post;[dl]*[/dl]I see what your saying Mavyak, but there has got to be an automatic check.

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login