maybe somebody knows a simple solution for this use case. My Part table has the following properties. Nothing really exotic:
item_number | erp_number | major_rev | name | ..
Both item_number and erp_number shall be unique values. When I tick the unique checkbox in the ItemType definition for both properties, a combination of the two properties will be used for the uniquness check.
There are use cases were this kind of unified uniquenss check is extremely helpful, like Part Goals. But in my use case I want to check item_number and erp_number indepented for their uniqueness.
What´s the most easy way to achieve this? Is there a way to prevent using a Method?
Thanks for any idea!