June 27, 200718 yr Currently all of our items have codes such as: MO-011 MO-300 IP-005 IP-255 TR-856 and so on. While making the data base I have noticed that when in find mode and when searching with certain criteria such as range and find MO-011 > I get strange or no results. It makes me thing that it happens due to - being used in item number. What are the potential drawbacks and or future problems, if any, using - in item codes. What is recommended - use the codes plainly as MO011 or is there a particular way that it should be done. The field is also set not to allow duplicate values.
Create an account or sign in to comment