I have a Data base that contain my product code and product name...but the problem is where my codes are unique but every unique code have so much different product name that are different in character and alphabet...for example :
all of that product code 1 is for one product but its name are different cause of operator's fault.
now the question is how can i show this product with code 1 and with just one of the product name ( it doesn't different which one)
sometime the difference between names are just ONE MORE SPACE.
Just check to be sure Vegar's post(s) got you what you needed for your use case? If so, please be sure to return to things and use the Accept as Solution on the post(s) that helped you get a working solution for your use case. If you still require further assistance, please leave a further update.
Here is a Design Blog post regarding the Mapping load Vegar mentioned too:
There are hundreds of posts in that area from our experts on how-to related topics for the most part, so you should find it very helpful.
To help users find verified answers, please do not forget to use the "Accept as Solution" button on any post(s) that helped you resolve your problem or question. I now work a compressed schedule, Tuesday, Wednesday and Thursday, so those will be the days I will reply to any follow-up posts.