
One opprotuniyty may have multiple project associated in the realated list.
How would I create this validation?
2 respostas
What is the relationship between the two objects? i.e. how does a Project show up on the Opportunity? Does it show up in a Related List under the Opp Detail section? Or does it show up in a Lookup field on the Opp Detail section?
If it shows up in the Related List section, you'd have to have Projects as a Master/Detail Relationship in order to use Roll-up Summary fields on the Opportunity. If it isn't Master/Detail, you might be looking at Apex code to make this work.
If it shows up as a Lookup field on the Opportunity Detail, you should be able to create a validation rule that looks through that Lookup to the Project record where you can compare the Status of the Project with the Status of the Opp.