Ref more than one columns between tables

[lucabizzotto]

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?

[TeeSee1]

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)

[lucabizzotto]

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?

[TeeSee1 · Accepted solution]

https://support.google.com/appsheet/answer/10107396?hl=en

[lucabizzotto]

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

👋