I have an Injury Register table in Dataverse that includes a Case Manager column, which is a Lookup column to the User table. Here's what I need to achieve in my model-driven app:
When a user creates a record, they should always be able to see it.
When a Case Manager is assigned to the record, that assigned user should also be able to view the record.
Both the record creator and the assigned Case Manager should have access to the record in the app.