I have got a scenario so break it down to simple is i will consider two companies , three employees
Company A: employee 1
Company B: employee 2
Employee 3 : few records of company A and few records company B.
First two point where Company A and has associated employee 1 and sees all the records associated and similar for company b and emp 2
Now Emp three should be only allowed to limited records in company A and limited records in company B.
In actual scenario there would be more than 100 companies and multiple employees like emp 3 who will have records across companies.
Table 1
| row | Company | Employee access linked to company | Empolyee 3 access allowed or not |
| row1 | CompanyA | emp1 | No |
| row2 | CompanyA | emp1 | Yes |
| row3 | CompanyA | emp1 | No |
| row4 | CompanyA | emp1 | Yes |
Table 2
| row | Company | Employee access linked to company | Empolyee 3 access allowed or not |
| row1 | CompanyB | emp2 | No |
| row2 | CompanyB | emp2 | Yes |
| row3 | CompanyB | emp2 | No |
| row4 | CompanyB | emp2 | Yes |
Now what is the best to implement this using security roles , teams , BU. Please suggest.