All 4 objects have a formula field (Checkbox) called 'Active' that is based on start / end dates.
What I need to do is to prevent users from changing the Account for the Contact if the 'Active' checkbox is checked for any of the related object records.
I could use a rollup summary field on Contacts, but that field cannot distinguish between the Active / Inactive state so it would the change if ANY related records existed - active or otherwise. (Rollups don't work with formula fields)
Any ideas on how I can achieve this?
2 respuestas
I see what you're saying Jeff. What would your approach be? I'm looking for any solutions to my requirement.
