Search for already Existing Record

Hi, I have a scenario where user wants to check whether the record already exists or not at the time of creating record. For Example: User wants to create a product ,clicked on add record button of...