# Single Relation and Numbers **URL:** \ **Category:** Ask for Help\ **Created:** [April 19, 2024, 10:12pm UTC](https://community.glideapps.com/t/single-relation-and-numbers/72742 "2024-04-19T22:12:17Z")\ **Posts on this page:** 6\ **Page:** 1
**Author:** ![Michael\_Rudin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/michael_rudin/32/73903_2.png) [@Michael\_Rudin](https://community.glideapps.com/u/Michael_Rudin)\ **Post date:** [April 19, 2024, 10:12pm UTC](https://community.glideapps.com/t/single-relation-and-numbers/72742/1 "2024-04-19T22:12:17Z")
I have a table with cars and a table with prices per car. If I want to make a single relation in the first car table to the prices, it doesnt work and will only get me the name of the car instead of the price. If I replace the price numbers with letters, it works fine. Is there anything I need to know specifically with numbers and single relations? Why does it not work? thanks ---
**Author:** ![Eric\_Penn](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/eric_penn/32/73888_2.png) [@Eric\_Penn](https://community.glideapps.com/u/Eric_Penn)\ **Post date:** [April 19, 2024, 10:21pm UTC](https://community.glideapps.com/t/single-relation-and-numbers/72742/2 "2024-04-19T22:21:29Z")
With relations you want to find matching values in both tables…i.e. the VIN number in table A matches the VIN number in table B. Then add a lookup column and select the price via that single relation. > **[Relations | Glide Docs](https://www.glideapps.com/docs/relations)** > > Create relationships and link rows together. > **[Lookup | Glide Docs](https://www.glideapps.com/docs/lookup-column)** > > Retrieve values through a relation. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [April 19, 2024, 10:32pm UTC](https://community.glideapps.com/t/single-relation-and-numbers/72742/3 "2024-04-19T22:32:18Z")
Just to add… Relations don’t return specific column values. They create links to rows that have the same matching value. Key word…ROWS. You may see a specific column value in the relation column, but it’s somewhat random and really just telling you that the relation found a matching row. A lookup column is what actually retrieves a specific column from that related row or rows. ---
**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\ **Post date:** [April 20, 2024, 1:35am UTC](https://community.glideapps.com/t/single-relation-and-numbers/72742/4 "2024-04-20T01:35:36Z")
With the amount of times we have had to specify this, it would be better if Glide just label them “Row 1”, “Row 2” etc. ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [April 20, 2024, 2:38am UTC](https://community.glideapps.com/t/single-relation-and-numbers/72742/5 "2024-04-20T02:38:13Z")
Agreed. I usually don’t care what the relation is showing. All I need is confirmation that the relation found matches. ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [April 24, 2024, 6:07pm UTC](https://community.glideapps.com/t/single-relation-and-numbers/72742/6 "2024-04-24T18:07:05Z")
Once upon a time I knew the rule that defined what information was shown in the relation, but there always seemed to be an exception. If one reorders columns at the very left of the table, what the relation displays will change. The basic idea is to have a basic text column, descriptive if possible, as left as possible.