If you have 2 agents with the same name, the code of which one should be displayed ?
Are you trying to enter in agent data on a Sales record, for example? Or are you trying to find the Agent record?
If you are entering Agent data on a Sales record, then you could have a script trigger on the field where you enter the name. When that field is exited, the trigger would fire and go look up the Agent ID (if one is found), and put that data into the 'ID' field.
Siplus raises a good question, though: what if there are multiple agents with the same name?
And then you could do the same thing on the AgentID field: a script trigger that would fire to retrieve the Agent name and put that information into the 'Name' field.
If incase I will have two same NAME in Agents Name field, I should have a freedom to select which Agent Code should I choose to reflect in Agent Name (Surely there will be no identical Agent Code, like in a Bank you can have SEVERAL bank accounts numbers with the SAME account name). I am trying to make a simple solution the objective is to collect data in the field.
As I have told before I want that Sponsor or Agent Name to automatically display the Agent or Sponsor Code on below field, how can I do that?. I have no background in programing.
I Attached the screen shoot of my layout for your reference.
Thank you, I will try to replicate this to my solution.