[SalesForce] How to Populate text field values onto a lookup/picklist

Subscribe system object has a text field "legacy ID". 1 account can have many unique legacy ID. I have a new object Sub Details wherer I want to populate a picklist/lookup containing all legacy ID upon choosing 1 particular account, so that I can choose a particular legacy ID.

I have tried the following:

  • List itemtried formula field, but can't because there are many legacy IDs for 1 account
  • Tried lookup from Sub Details to Subscribe system.

How to proceed?

Best Answer

Picklist ? is questionable because you will have to resort to 'Metadata API'. As for 'lookups' you can try using 'filtered lookup'

Refer to: http://help.salesforce.com/apex/HTViewHelpDoc?id=fields_lookup_filters_defining.htm

Related Topic