Member Avatar for ivantju
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

  • 1 Contributor
  • 0 Replies
  • 40 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.