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. [relation settings] [result] [relation to]

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.

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.

[image] Table data not linking despite relations column Ask for Help Are you using that relation as the source of your collection?

Relation column problem

Ask for Help

Jeff_Hager August 17, 2025, 5:54am 4

Topic		Replies	Views
Table data not linking despite relations column Ask for Help	4	60	August 17, 2025
Relation brings back info from wrong column Report a Bug	6	727	January 8, 2021
Relation not returning the proper data Report a Bug	5	812	May 29, 2022
Relations field not populating Ask for Help	11	155	October 13, 2025
Relation not populating column Report a Bug	6	594	May 8, 2020

Relation column problem

Related topics