CRM On Demand - Administration (MOSC)

MOSC Banner

Field Validation on Grandparent record..

edited Oct 15, 2010 4:37AM in CRM On Demand - Administration (MOSC) 4 commentsAnswered
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center