We have custom objects that are used to capture test scores for people who apply to our programs, such as GMAT. Currently, these have a Master-Detail relationship to Accounts, but I would like to start capturing this data at the Lead stage. Leads are not an option, however, for Master-Detail relationships.

Is there a way to add Master-Detail relationships to Leads and have them transfer when converted to Accounts?

Attribution to: Mike Chale

Possible Suggestion/Solution #1

As of Summer '12, lookup fields can now have Master-Detail style characteristics including requiredness and directions what to do when you delete the parent lookup record. Check out: http://developer.force.com/releases/release/Summer12/lookup+relationship+enhancements for more information.

Attribution to: Adam Torman

Possible Suggestion/Solution #2

You could add a Lead lookup on the object and then have trigger logic that runs on Lead Conversion to link the record associated with the lead to the Account by setting the Master account lookup.

Attribution to: techtrekker

Possible Suggestion/Solution #3

Yes this is perfect Trigger scenario.First establish relationship between Leads and that custom object .Now during Lead conversion you can definately have a trigget to meet your requirements .Be careful of the check box we have on lead which decides whether to fire Trigger or Not

Attribution to: Mohith Shrivastava

Possible Suggestion/Solution #4

If you need to keep track of that much information about a Lead, you may want to consider simply eliminating Leads from your Sales process, or converting to an Account and Contact as soon as you have a Test Score.

This will eliminate duplicating effort and writing custom code to properly convert this relationship. My advice on Leads is generally to convert them as soon as things get interesting or complicated, which seems like the scenario you're describing.

Attribution to: Jeremy Nottingham
This content is remixed from stackoverflow or stackexchange. Please visit https://salesforce.stackexchange.com/questions/1833