Ref and dereference problme

[lior_zioni_danc]

I have a Studentslist table and orders table
in the "new student form "that I fill the “first name” and “last name” and I have a Column "full Name " with a formula CONCATENATE([First Name], “”, [Last Name])

in orders form, I have a ref type for column "Full Name " dropdown ’ ref to full name in sudentslist table

1. when I open the dropdown I see besides the Full name I see a yellow triangle … why does it happened?
2. I want that after I choose a name in the order form. I want that it will show me his Phone from the column Phone In the Studentslist table.
   I tried to put a formula in the Phone column in the form [Full Name].[phone] and it didn’t give me anything
   any advice?

[Steve]

A Ref value should be the key column value of the row referenced. The yellow triangle indicates the Ref value you’re using doesn’t match a value in the key column of the target table.

help.appsheet.com

References Between Tables

Learn about references, when to create them, and how to use them so that your data makes sense.

[lior_zioni_danc]

i dont know what i did’ but it disaper’
but now when i see the rec in google sheet in the column name i see a num or the key uniqueid

[lior_zioni_danc]

Tnx for the link
In my case can i make the custumer name a key value ?
but a key value sould be unique and names not always unique
There is other way to do it ? other method ?