Permission management for Client and its related Collection

how I do prepare the collection and to perform this. please note that I do not use the relationship as it is not stable and maybe complex.

let say I have a client collection ( where specific clients are assigned to specific usersss to read only, to read/edit, and admin to do all.

And, I have other collection, followUp, which related to client collection. and users having the same permission as if they have for the client collection.

For example the collecton like this

ClientId, ClientName, ClientDOB, Others

Id, ClientId, Date, Notes (how to make Id, ClientId are PK) which cant be duplicated.

So in the page will be , where to show all the users having permission to the specific client. let say I access ClientId 1, then I see who has permission to that client and so on.

what is the proper way to handle this ? please kindly share me . Thanks. make it better and clear

👋👋

Maybe a team per client with different roles for the different access?

can I query documents like where $permission includes userId [a,b,c] . something like this.

No

any solution ?