Skip to main content
I created a custom object and tab that lists all partner opportunities, I want my sales team to be able to add an exisiting record (partner opportunities) from the partner opportunity related list on their account page. So instead of creating a new partner opportunity from the related list object on the account record I want them to select an add button that lists all the current partner opportunities so they can choose the correct one and have it displayed as a partner opportunity in the related list on their account record.
1 个回答
  1. 2011年3月2日 22:29
    Hi Karen,

     

    In Help and Training there is an Article named "Creating a Many-to-Many Relationship" which can help you.

     

    In short, you'll create a 3rd "junction" object called something like Account Partner Opportunities.

     

    This object is actually what is used on your Accounts and Partner Opportunities layouts (it's your related list)

     

    The junction object records each have 2 parents, the Account, and the Partner Opportunity.

     

    You can make the related lists appear to display the related Partner Opportunities under an account and vice versa, the Accounts under Partner Opportunities.

     

    From the Account related list it lets you "lookup" and existing Partner Opportunity rather than creating a new one each time (what you're trying to do)

     

    Once it's setup you can customize the related lists to actually show values from the corresponding records... for instance you can setup your Account /Partner Opportunities related list to show Partner Opportunities fields that you want to see at a glance in the related list.

     

    All this is explained in the article and how to build it step by step. I'd give it a try in sandbox and check it out.

     

    ***Make sure not to browse/skip and steps, there are some important little factors like not accepting the default names for your related lists when you make the master details lookups, etc.

     

    Hope this is helpful,

     

    Dave
0/9000