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
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.
1 Like
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.
4 Likes
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.
4 Likes
Agreed. I usually don’t care what the relation is showing. All I need is confirmation that the relation found matches.
1 Like
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.
1 Like