Field Validation on Grandparent record..
Hi,
We have customized 3 objects namely Sub-Event (Custom Object 1), Allocation (Custom Object 2) and Attendee (Custom Object 3). In Sub-Events object we have a field called 'Sub-Event Status' and also we have a field on Attendee called 'Attendee Status'.
Now the requirement is that users can only create Attendee records if the 'Sub-Event Status' = 'In Progress'. Also, there is not a direct association between Sub-Events and Attendees. They are related using the Allocation object. Meaning that Sub-Event has a child record as 'Allocation' and that 'Allocation' record is a parent record for 'Attendees'.
So, since we need to put a validation on the Attendee record (Grand Child for Sub-Event) we need to lookup at the Grand Parent record 'Sub-Event' and have the field value for 'Sub-Event Status' copied over to the Attendee record and then place a validation.
We have customized 3 objects namely Sub-Event (Custom Object 1), Allocation (Custom Object 2) and Attendee (Custom Object 3). In Sub-Events object we have a field called 'Sub-Event Status' and also we have a field on Attendee called 'Attendee Status'.
Now the requirement is that users can only create Attendee records if the 'Sub-Event Status' = 'In Progress'. Also, there is not a direct association between Sub-Events and Attendees. They are related using the Allocation object. Meaning that Sub-Event has a child record as 'Allocation' and that 'Allocation' record is a parent record for 'Attendees'.
So, since we need to put a validation on the Attendee record (Grand Child for Sub-Event) we need to lookup at the Grand Parent record 'Sub-Event' and have the field value for 'Sub-Event Status' copied over to the Attendee record and then place a validation.
0