Data type with lookup wizard

[Chunk]

Heres something I dont understand about the lookup wizard:

Ive done a lookup wizard on one of my fields, so that now the user gets a drop down list of options to choose from:

0;1;2;3;4;5;6;7;8;"NTSC";"PAL"

Ive also set "Limit to list" to yes, so that these are the only options the user can enter.

However, it will still let me change and play around with the data type settings under the general tab. I dont understand why it lets me do this. I can set the lookup to the above list, and then specify a date type of type "date", and it will allow me to do it.

Why is this the case? Which datatype should I set it to, if I have a list of values like the one above?

 

[The_Doc_Man]

First, if you are the administrator or owner of the object in question, you can always change its data type. You have to revoke your own ability to modify the design in order to stop this.

Second, that list HAS to be text because it contains text elements. However, you also have digits in the list. They should probably be stored in quotes to prevent them from being considered numeric. But maybe not, since I'm not clear where you have this list.