but seems, it has not solve the problem... you may refer to the image below... after clicking Edit at any entry in Customer (image shows if i click test2), Industry Category & Industry Title entry is "-Select-" instead of "electronics" for Industry Category & "robotics" for Industry Title..
the problem is still there! besides grouping Industry Category & Industry Title accordingly, the purpose of the script is to eliminate duplicate entry under Industry Category field.. commenting the script works in Edit but you still can see duplicate issue under Industry Category as image below.. it does not solve my problem..
actually, as you can see in my script, there are few Industry Title that fall in one single Industry Category.. for example, in "Robotics", "Electrical" & "Telecommunication" Industry Title fall into one Industry Category which is "Electronics".. this is why duplicating entries happens in the Industry Category.. you may view my script to get clearer idea regarding this..
Sorry we are not able to reproduce the issue. The script works fine and the field does not show any duplicate entries. We have also attached that screen shot in which there are no duplicate entries are found. As a suggestion you can also use the Aggregate function for fetching unique values.
Leave a comment on Ramyabharathi's reply
Change topic type
Link this topic
Provide the permalink of a topic that is related to this topic