Ref column dropdown

[Mordan74]

Hi all.
I have a table that has a Ref column that references a table with a key column that is a concatenation of:
Brew date-Brew name-Batch Number

When I use the dropdown to create a new record all I can see is the Brew Name to select from without the date or the batch number.

This is obviously a pain since there are multiple brews with the same name but what makes them unique is the date it was brewed and the batch number.

If I just select one, the result in my spreadsheet is the full computed key.
It just seems to be what is shown in the dropdown to select the referenced row.

[Suvrutt_Gurjar · Accepted solution]

I believe in your parent table the label column assigned is [Brew Name]

Please assign the concatenated column of Brew date-Brew name-Batch Number as label column and test.

[Mordan74]

Yep that did it. So simple and I had tried that but on the wrong column previosuly.
Thanks for that.

[Suvrutt_Gurjar]

You are welcome!
You may wish to browse the following sample app and help article to know how labels get displayed in the reference dropdowns.

help.appsheet.com

Row Labels

How to determine which columns are prominently displayed in a view.

https://www.appsheet.com/samples/This-app-shows-the-difference-between-keys-and-row-labels?appGuidSt...