You need to sign in to do that
Don't have an account?
Adii
Create a junction object named ‘Job Application’ between two objects named ‘Position’ and ‘Candidate’.The position and candidate has many to many relationships which will be established due to the junction object. Create a status field of type picklist on
on both position and candidate. If the status on a candidate record is updated to ‘Approved’, the status field on position should be updated to ‘Approved’ only if status on all related candidates have been updated to ‘Approved’.
I think one possibility is to use a trigger so as to check and then update the values according to your conditions.
Does the above way help let me know!
Regards,
Anutej