Lookup / Dropdown

[Siger_Smit]

Hi all,
I have an Tracks table with a Artist column. And I have an Artist table with a Artist name column. I want the user to select an Artist name. So I use a EnumList with a ValidIf expression (Artist[Artist name]). But I want the user to also create a new Artist when necessary.

I tried this Article but I can’t get it working the way I want it. I now have two columns in my spreadsheet, Artist and Other… But no new entries in the Artist table… Is there more indept information on this specific pattern? Thanks in advance.

[Aleksi]

It sounds that you should use Ref field instead of EnumList. Check this article… https://help.appsheet.com/articles/961426-references-between-tables

[Siger_Smit]

@Aleksi Thanks for your reply.
I hace tried the Ref field, but you can only select one item, but in this case a Track can have multiple Artists. And for example multiple Record Labels. Or is there an option for selecting multiple values?
Also there are a lot of References, but only one IsPartOf is allowed, right?