I have $2$ dataverse tables in model driven app. Customer and Visit, One Customer can have many Visits.

Right now as a security role I have user key for Create,Read,Write role for both tables. So right now they edit records in model driven apps in which they are the owner.

But for Visit table I want permissions in security role by which 'I can edit visits record where they are the owner of Customer record' as they have relationship.

Please provide proper solution.

Do we need row level security or any businees management role change or more access in security role, please provide whole solution.