Relation column problem

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.

1 Like