Cascade Modify role to a child table from parent table based on user field in parent table

Parent table 'Customer' with field 'Customer Representative. Child table 'Project'. Is there a way to only allow the customer representative to have access to projects where they are the custo...