You need to sign in to do that
Don't have an account?
How to get multiple value in a field using lookup or multi select picklist
Hi,
Actually my scenario is that i have two field one is named as customer name which is lookup with account and another is account number which is a formula field after selection customer account number will automatically populated.
But, the scenario is that one customer having more than one account in account object so after selection the customer name ,for account name there i want some functionality either multiselect or lookup field so that in that user can select some of the account for that customer.
How i can implement this functionality.Please pleasr help me out from this problem.
Thanks in advance.
sorry i dont have any code for this as i didnt worked on anything like before, just give a try with what i suggested earlier.
thanks
--yvk
All Answers
Dear Satyam,
Here is my understanding:-
In salesforce, Picklist cannot have more than one value selected at a time. Because a single field cannot have more than one value at given point of time. So your requirement of "Multi Select Picklist" is not possible.
Your requirement is not clear at all.
My questions are:-
1. What are the objects? i.e. Customer and Account?
2. What kind of relationship they have? i.e. Lookup/Master-Detail/Self/Many-to-Many?
Please rephrase your requirement once again so that I can suggest you possible solutions.
Thanks,
Prolay
Hi,
I have 2 object and in first object which having lookup field named as customer name from account.after selecting that customer name all the account for that customer in account object having customer number like example
acc no are 23,24,25,26
i want these four value in multiselect picklist field in my first object where user want he can select either 2 or 3 acc no and save the record.
Hope u can understand....
Thanks:)))))
Dear Satyam,
I am wrong with my ideas. The Multi Select picklist is possible. Please elaborate your requirement so that I can give you possible solution.
Cheers!
Prolay
Please consider these points:-
2. You may need to develop Visualforce pages to meet this requirement. You may find this post valuable http://boards.developerforce.com/t5/Apex-Code-Development/Querying-and-setting-multi-select-picklist-values/td-p/157065
Please let me know if you need further information.
Cheers!
Prolay
Hi Prolay,
I am not getting what is going on this link.
Can u have some code which u already did or some example so that i can take some hint from there.
Thanks :)))
Hi Satyam,
I dont think its possible to tie multiple references of an object with a single field unless if you decide to go with complete customization.
If you are looking for a customized solution, then you can have visual force page with a controller. On the page you can have a text field Customer Name, you can use any possible action events like onBlur, onKeyup and retrieve the list of all possible Accounts and display them dynamically using a multi select picklist. Then you can store the multi selected values in another text field based on your requirement.
The only way to tie multiple references to a record is to have multiple lookups referring to the required object.
Hope I undertood your reequirement
--yvk
Hi,
Yes You r right but how this i can implement can u have some code for this where u implemented this schenario.
Thanks :))))
sorry i dont have any code for this as i didnt worked on anything like before, just give a try with what i suggested earlier.
thanks
--yvk
Hi,
Can u give me a trial so that i can modify it according to my requirement.
Thanks:)))