Parent (SUITES) / child (TENANT). SUITES owns TENANT.
Suites.Tenant = relationship of all Tenants owned by Suites.
Teant.Suite = relationship from Tenant back to Suite.
During an Create/EDIT of the child (TENANT) , if I turn on a value, on save I want all other children of this parent value turned off. There can be only one active. I have a few rules on the BO to do calculations on save, and then end with check if you have turned this value on. However it's turning all children values off, including the one I just saved. I've tried separating it into a process, but same results.
CONDITION
Tenant.Active = 'YES'
ACTIONS:
- Find Tenant Where Tenant.Suite = ThisTenant.Suite and Tenant.ID <> ThisTenant.ID
- Tenant.Active = 'NO'
- Tenant.Suite.Vacant = 'NO'
- Tenant.Suite.ActiveTenantNo = Tenant.ID
- Tenant.Suite.ActiveTenantName = Tenant.Tenant
