Hello everyone,
I have a problem with ref.
I would like to refer two columns of one table to another table, but I get in both refs the values of only one column (refA and refB in Tab1 turn out to have the same values).
Why, what am I doing wrong?
Solved! Go to Solution.
Ref columns point to the key column of the target (referenced) table.
A table only has one key column. So by definition, you can only create ref columns to a table that point to one column (the key column)
Thank you for the super fast response.
I understand now. Then the problem becomes another: how do I retrieve the exact column of the table?
Example: I need to retrieve the truck type ("truck type" table) in a customer order ("customer order" table) and I can do it through the truck chassis, but also through the truck license plate.
In the "customer order" form, how do I retrieve the right row of "truck type" through the "chassis" column or the "license plate" column?
Thank you very much @TeeSee1
I found also this topic in community that make me the job easier๐๐ผ
https://www.googlecloudcommunity.com/gc/AppSheet-Q-A/More-than-one-label-in-Ref-list/m-p/281017
๐
User | Count |
---|---|
42 | |
25 | |
25 | |
17 | |
12 |