Standardization of names in a flat List

SAshish

Hi,

I have a flat list to maintain the certification records of the employees. Users will make use of that list in order to update the certification. If a user comes up with a new name then that name will get added to the list. But the problem now is that the names are not standardized and as a result we are getting same name certification twice or thrice. e.g., 1. SAP_Certified_Admin & 2. SAP Certified Admin(SPA). (This is just for the sake of example and not a real name)

How can this be made sure that if a user wants to add a new record for certification for SAP Certified Admin then he can only add one of the either names, also once added there should be an error message saying that the name already exist if any other user is trying to add the same record with another name.

jagadishdash

@SAshish

I understand the naming is different but it refers to the same certification. Do they have any standardization certifications? Like these are the 5 certification can only get but name might be different! If that is so we can give them a dropdown selection to select from the standardize certifications.

If it is not the case and can be any certification and name can be anything that we are not aware of so that means we can't handle it directly. One other thing you can think of, there's a text field for the name of certification and need a dropdown beside that to map the exact certification if it's not there in drop down then action to create that specific item in the list.

Let me know if anything else I missed to take care while giving the solution.

Thanks,

Jagadish