Section Access match two fields

[StacyCui]

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
...	…	…

[Vegar · Accepted solution]

You can solve it like this using a link table. 

Link:

Load Key1 , Key2, Key1 as Key Resident OrTable;

concatenate (Link)

Load Key1 , Key2, Key2 as Key Resident OrTable;