Is it possible to relate multiple records to a single lookup field (or) Is there a way to create a multiselect picklist/longtext field and dynamically fill in a related object info in the picklist, where the user can have a clickable link to the record?

Please let me know if there is a hack to do this.

Attribution to: Rao

Possible Suggestion/Solution #1

If you went with a multi-select picklist you could use a formula field to generate the links.

Example formula field definition using a multi-select picklist:

IF(Includes( LinkSelect__c , "Google"),  HYPERLINK('http://google.com','google') ,"") & " " &
IF(Includes( LinkSelect__c , "Bing"),  HYPERLINK('http://bing.com','bing') ,"")

Things to consider:

• The Hyperlink function will work with fields so you can have dynamic data
• This approach requires hard-coding values for the comparison
• You can see more about Includes and Hyperlink in the documentation

Attribution to: Mike Chale
This content is remixed from stackoverflow or stackexchange. Please visit https://salesforce.stackexchange.com/questions/2232