I have the following set of tables:
A (key1, key2)
B (key2, key3)
In that case, every key1 can have multiple key2 attributes in table A and every key2 can have multiple key3 attribues in table B.
When I would use a conditional lookup field for table A to get key3, it would only give me one of the key3 attribues, is it possible to take all values?
I know I could do it with a simple custom view left joining on key2, but is there are recommended way to do it in Discovery Hub without custom views?
So the goal table should be like
C (key1, key2, key3)