i am wondering if there is a way to use same column so that you can put free text or choose from a list of items?
what i want to do is that user can enter free text in the field and as he typing a list of suggested items show up if he does not want any he can continue putting what he wants.
i am aware about the enum with allowing other values but has two issues
1- it takes you to another window to choose the items.
2- if u added another value it will remember it every time and maybe be shown to other users.