Deref and the dreaded yellow triangle!

[ten4info]

Setup deref and it is working, but I am getting the yellow warning triangle along with the value return.  There are a number of records in the lookup table that do not have a Contact value and where there are duplicates of the Company Name.  BUT, there are not actual Contact duplicates (other than blanks where I do not have an actual Contact value inputted).  Help!

And thank you!

[SkrOYC]

Post here your Valid_if and column config

[ten4info]

@SkrOYC , I am sorry, not following your reply.  Can you clarify?

[ten4info]

@SkrOYC, does this help?

[SkrOYC]

Your columns has to save key values, it's what is called a Foreign Key column.
You have an Initial Value of [Company Name] that clearly is not a Key, so it shows a yellow triangle to denote that

[ten4info]

@SkrOYC, but my Contacts is my Key column in the table that is being referenced.  Can a table have two key columns?  Then what would the Key column be in the Activity form?

[Marc_Dillon · Accepted solution]

Change [Company] column to Text, not Ref.

[ten4info]

Thank you @Marc_Dillon 

[flo3]

thank you  @Marc_Dillon 

[Steve]

What is a key? - AppSheet Help

References between tables - AppSheet Help

[ten4info]

Thanks @Steve I'll check these out.