Is it possible to convert TextField to Relate field?
Are you wanting to change an existing field?
Depending on what you are trying to achieve you may be better off adding a custom relate field and hiding the text field from view.
Note that a Relate field actually stores the ID of the related record, while in the text field you most likely have the name of whatever it is you are referencing. So if you already have data in there you will need to update it somehow to replace all names with ids....
If you can share more about what you are trying to achieve there may be other suggestions.
Thank you very much
For your quick reply on this.
What we a re trying to achieve is that
On a Case we have already added a custom field "Client" as a TextField.
So whenever we create a Case, we are putting String "Client Name" into the Client field on a Case.
Now we have already imported all of our clients into Account module of Sugar. So far this are not related.
Now user wants to have a drop down option when the user are entering a Case on a Client and the value of Drop down should come from the Name of the Account Module.
So that's why i was looking to have some options.
Please let me know if you need more details on this.
As I see it your best option is to add an Account relate field to Cases (if there isn't one already) and start using it to relate Cases to Accounts (aka Clients).
For the cases you already have, you have a couple options that depend on how many Cases and how many Accounts there are and how precisely the Client name was entered on the Case:
I will take the your suggestion and make necessary changes.
Retrieving data ...