How do I create a drop down where I control w...

[Daisy_Ramirez]

How do I create a drop down where I control what the user see’s but it CAN allow other values?

I understand we can use the Valid_if to control the values with a SELECT expression but this prevents other background values from entering the column.

Thanks

[pravse]

If you are using an Enum, there is an option in the column definition called ‘AllowOtherValues’ ?

[Daisy_Ramirez]

Nn enum. Its a ref field

[pravse]

If it is a ref field, it will give you the option to add a new entry in the referenced table.

It sounds like what you want is really just a text column or something with a dropdown of hints that come from a referenced table.

We don’t have this mechanism.