+ Start a Discussion
Just Code ItJust Code It 

Master Data Implementation

Hi All, I come from custom app development (Java, .NET etc.) and new to Force.com platform. I have one custom object named "Country Code" with two fields ID and Description (ID = US, Description = "United States", for example). I would like to display the value in the "Description" field as drop-down in Account object, in the "Country" field of the Account object. I also need to send record in in Account object to external application (via Web Services, for example). However, the value of he "Country" field in Account object needs to be from "ID" field, not from "Description" field. The Lookup field is the closest I found but it does NOT allow to display in drop-down. Standard Piclist does not provide a method to include the "ID" value as well. This seems to be a common programming problem, is there any standard mechanism supported by Force.com? Or is there any design pattern that can be recommended? I was looking at metadata API to create custom solution for Picklist, any advise? Thanks in advance,

Best Answer chosen by Admin (Salesforce Developers) 

When we've had this scenario in the past, we've created a visualforce page to embed in the record view that presents the available records as a drop down.


The only thing that's slightly odd ofor the user is that they "edit" this information in the record view page.