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.