Ticket #30766
Question
I am trying to join to an additional table. Its only showing me 2 tables which I can join to. I have way more than just the 2. Is there a reason for this? In old UI I seemed to be able to join to more. See attached screen shot.
Answer
Customer was trying to join on two fields with the same name but the cases were different. This caused the match to not be found. Customer created synonym between the two fields and all worked as expected.
Asked on November 2, 2020