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.