limit related entities to records with specific property value
I have a hierarchical entity, Org Structure with a Choice property, Unit type. It is a lookup property on the Profit Centre table. Profit Centres may only be related to Org Structures of type "department".
I've created a "Department view" to use on forms. But this still allows form creators to make a form where the business requirement would not be enforced. Granted that this is a low risk, but I'd prefer to forbid relationships with Org Structures of the wrong type. Is there a way of doing this?