This article gives an example of an advanced validation rule that navigates to parent and child records from a central entity (Customer). If you are struggling to write SemQL for a complex business requirement, this example might give you ideas on how to structure your own validation rule.
This is a Customer B2B use case. Here are some relationships between entities in this B2B data model.
- Customers (child) belong to a MasterCustomer (parent)
- MasterCustomers (parent) can have many SubGroups (child). SubGroups are a way to categorize different Customers within 1 MasterCustomer.
- Customers can belong to many SubGroups... (More)