Use ref column as values for EnumList

[jrsmith252]

Hi.

I am trying to create a form where one of the fields is a list of options, of which multiple can be selected, taken from the values within the column of another table.

When I select "Ref" as the type (for the field), it does bring about a dropdown of the values that I would like to offer. However, only one can be selected. When I select "EnumList" as the type, I cannot seem to link it to the Ref column (entering it into the Base Type does not work.)

Thanks in advance.

[SkrOYC · Accepted solution]

You have to also add the list of available options inside Valid_If or Suggested Values.

This should be a list of keys (Like TableName[KeyColumn] or similar).

If you use it in the Suggested Values, it will allow input for new ones.
If you use it in the Valid_if, it won't.

You're welcome