Sorry I need to make sure I am clearly stating where these changes are to be made.
Brief explanation of Ref columns.
A Ref column type allows you to point to a “row” in another table. It requires being assigned the key value of the row. the key is stored as the column value in the sheet or database. But we don’t want to display the ugly key value in our views so AppSheet has also provided the ability to set a displayable value using the Label property. In views, where the Ref column is displayed, AppSheet will automatically replace the key value with the value of the Label column.
Ref columns have another advantage in that they allow direct access to any other column of that assigned row. E.g. Say the source table has columns “A”, “B”, “C”. A column set as type of Ref can access those other column using “Dot” notation. These would look like:
The setting of key and Label columns in a table is done regardless of how the table will be used in the app. Each table should be inspected to make sure the appropriate column is set as the key and assign a column as Label.
Brief explanation of EnumList with base Ref type.
The EnumList column type allows choosing of multiple rows. You can set various types of data to be shown in the dropdown list. One of these is a Ref base type.
An EnumList set with a Ref base type works very much like that described above for Ref columns. EXCEPT a user can choose more than one Ref row. The chosen row keys will be saved in the sheet as a comma separated list.
The definition of EnumList with a base type of Ref will look similar to this:
I am confused by your image showing UNIQUEID and musicians Ref column. You stated it is the musicians table. But you would not have a musicians Ref column in the Musicians table.
In a post above you showed a musicians column defined as EnumList. That is the column I am focused on trying to fix. It first needs to be correctly defined as described in the “Brief explanation of EnumList with base Ref type” above.
Then in the Musicians table:
- make sure the correct column is set as the key. Maybe it also has a UNIQUEID column? If so then that is your key column.
- set the column that has “Ed”, “Fidel”, “Alexis”, etc as the Label. (Name column?)
Now you need to fix the musicians EnumList selected values so that it contains the row keys and not the names. The easiest way is to use the app and go to that dropdown, clear the list, re-select the musicians and then save.
The list you are showing will still look the same but now the column will have saved the key values instead of the name text. This in turn should fix your Related Bands list.
I’d finally like to point out that there is not a lot of detail provided about how you have setup your app data. There is a big assumption that you have used the AppSheet provided features. If you have structured the data in an unconventional (i.e. unexpected way), that’s not a problem, we just may need to dig deeper with more details to resolve your issue.