EnumList from another table

[Bulubulu]

Hi,

I have two tables, one named "Episodes" and the other "Themes".
I would like to have an EnumList column in the "Episodes" table that lists all the themes in the "Themes" table.

In this way I could assign several themes for an episode and increase the list of themes later if necessary.

Do I have to go through an additional virtual column to do this? How should I do it ? Could you please help me ?

[Marc_Dillon]

Virtual columns are not editable by the user, so no, you definitely would not want that. What exactly are you struggling with? Perhaps this will help?

https://help.appsheet.com/en/articles/961544-dropdown-from-valid_if

[Bulubulu]

I would like to have a dropdown menu in the "Episodes" form that lists data from a column in the Themes table.
I tried this (see image), but the list is empty in the form and it asks me to enter the values manually. The goal would be precisely to recover the list of themes and to be able to add themes to this list later.

So I would like a drop-down menu whose content contains an editable list from another form.

[Marc_Dillon · Accepted solution]

Different from basic Ref columns, enum/enumlist with base-type Ref requires a valid_if or suggested values.

[Bulubulu]

Thanks a lot ! It works perfectly with this expression as suggested values :

SELECT(Themes[Theme], TRUE)