ivantju 0 Newbie Poster

I am currently creating a form for a shop database and this form is used to enter new record to the product database. in the form, we need to key in the code for the product and I want to have validation rule that checks the code entered is not empty, having 12 digits ( all numbers) and also must be different from all the codes recorded in the table. How do I create the validation rule?

Thanks