Hi, We have a business requirement. The scope is that if an user key can match either table key1 or key2 who could access this row. For instance: The key of A is 1001 so he can get ID 1 and ID2 of OR Table ,The key of B is 1002 so he can get ID 2 and ID 3 so on and so forth. Is there any solution for this issue?
User Section Access Table:
| User |
Key |
| A |
1001 |
| B |
1002 |
| C |
1003 |
| D |
1004 |
| E |
1005 |
OR Table:
| Data ID |
Key1 |
Key2 |
| 1 |
1001 |
1006 |
| 2 |
1001 |
1002 |
| 3 |
1002 |
1008 |
| 4 |
1006 |
1004 |
| ... |
… |
… |
