in one of my fields I allow user to enter new values. yet I want to give him the chance to choose from previous values entered in the same field.
I will use a combo box. so that I will let him choose or add a new value.
my question is: should I use a separate table to store values of this field? what is the best database design for this case?