The AI helps, but when it’s specific issues, it causes more confusion. I am trying to create a relationship column between 2 different tables. I set it up to and when pressing the query button, I get information, but not the correct information. Ive copy/pasted to ensure everything is the same but I cannot get it show the information I need. Please help.
What is the result you are expecting?
Note that a relation only establishes a link between rows, it does not contain any actual data. If you need data from the second table, then you will need to add one or more Lookup columns that fetch the appropriate values via the relation.
2 Likes
I read in an old post that the relation only sees the 1st column, so I swapped the Asset Location with Site Name and now it is showing correctly (this seems very limiting to me).
My issue now is that even though I am making a relationship column in the Equipment table to reference the location, when I tap on a specific Location with the goal of ONLY seeing equipment at that location, all the equipment is being populated. Im not able to only show equipment within a specific location.