DataType is stubborn

[Guest]

My TypeID had Number as its datatype. However, I tried to change it to
LookUp, it asked some questions which I answered, but found that the datatype
remained at Number. When I tried again, it asked me to break the
relationship, which I did and tried again. But the result was the same. Any
ideas? Thanks

 

[Guest]

HI

You are most liely seeing the primary field of the record you are
"looking-up".

Leave the table as it is (don't use a lookup at all in the table). Create a
form (or use one you already have) and use the wizard to create a combobox
that will lookup the values you need. You can use the column width property
to decide which type of data you see (which column of the recrod in the
combo) and you can also use the row souce to decide on the bound field.