I use lookup Wizard and in the Datasheet view has Dropdown list but when I choose it has ! and show text that " the value you entered does not match the number data type in this column " please help the way to resolve it
If you find yourself in a situation where you feel like this type of field is needed, check your design; the field in question might be better suited as a table.