The hierarchy goes:
-Reception orders: Provider, Date, Batch number.
-Products in batch: Name, Family, Group, Species, Size, Quality.
-Quantities: Kilograms, Box tag.
Each batch (reception order) contains different products. Product A can come in Batch #1, #2, #3 and so on… But I want to avoid the same product being registered more than once per batch.
How can I validate the Name of the product so it checks if it’s been added already?