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!
Solved! Go to Solution.
Change [Company] column to Text, not Ref.
Post here your Valid_if and column config
@SkrOYC , I am sorry, not following your reply. Can you clarify?
@SkrOYC, does this help?
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
@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?
Change [Company] column to Text, not Ref.
Thank you @Marc_Dillon
thank you @Marc_Dillon
Thanks @Steve I'll check these out.
User | Count |
---|---|
42 | |
29 | |
25 | |
23 | |
13 |