Hello,
I am currently designing a Dataverse structure where an index table where each row is connected to Entity A and Entity B through lookup columns. I am trying to prevent duplicate in a way that a row can't be entered based on the value of a column in entity B. Is it something that can be done?
Ex:
Item A is linked to Group A (value of the Company column in Group A= ABC) = Okay! ✅
Item A is linked to Group B. (value of the Company column in Group B= DEF) = Okay! ✅
Item A is linked to Group C. (value of the Company column in Group C= ABC) = Not okay! ❌

Report
All responses (
Answers (