Adding A Field to the Database Index

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

I have created a custom field named rec_lock_c (Record Lock) which I want to add to the database’s index list which currently includes parent ID, name and email address. These fields are used when checking for duplicates when importing accounts into the database. How can I add the Record Lock field to the index so I can lock records to prevent them from updating a record(s) when importing accounts?
Haven’t seen the option to add this field in the Admin panel.

Do I need to add some code and what is the code that needs to be added and where?

Many thanks for your responses.

2

For any one who needs an answer to this question, I found an interesting article that explains how to achieve it,
I tested it and it worked for custom fields but not for standard fields. If anyone knows how to do it for standard fields he is welcome to share his solution.

Article with working solution for custom fields:
http://techs.studyhorror.com/sugarcrm-custom-field-duplicate-checking-import-i-102