I need to be able to get some data from table b using a reference in table a as well as the value of another column in table b. For Instance:
Table a has a pointer to table b. In table b, there is a type column that could be "a","b","c" or "d" and a multi line text column. I want to be able to lookup the text column with the reference pointer and type = "a" or "b" and so on when I'm doing stuff in table a.
Thinking back to my SQL select statements, This is not a hard thing to do. can It be added to Teamdesk or is there an existing way to do this?