I have an Injury Register table in Dataverse with a Case Manager column, which is a Lookup field pointing to the User table. I want to set up permissions in my model-driven app as follows:
The record creator should always be able to view the records they created.
When a Case Manager is assigned to a record, they should also be able to view it.
Both the record creator and the assigned Case Manager should have access to view the record.
Additionally, when a Case Manager logs into the model-driven app, they should only see records where their name is in the Case Manager column of the Injury Register table.
How can I configure this behavior in my model-driven app?