Skip to main content
Hi,

 

I have three custom objects: A, B and C.   Object A is the Master side of a Master-Detail relationship with object B and another Master-Detail relationship with object C.

 

I added a many-to-many relationship between objects B and C with a new object "D" which is the Master side of a Master-Detail relationship with "B" and also is the Master side of a Master-Detail relationship with "C".

 

Everything works fine except for one small problem.  When I am adding a record in "D" with a value from "B", I haven't been able to figure out how to filter the available records from "C" so they only include the primary object in "A".

 

For example:  The values in "A" are organizations (Head Start, United Way, etc).  The values in "B" are campaigns being held by the organizations.  The values in "C" are the coordinators who work for the organizations.

 

A campaign can utilize many coordinators.  A coordinator can be part of many campaigns.  A coordinator may never be part of a campaign, but we still need to log conversations and meetings between our company and the coordinator.

 

                                                  Organization (A)

 

                                     (one to many relationships to)

 

                      Coordinators (C)                              Campaigns (B)

 

                             (many to many relationships between)

 

                                                  Joining object (D).

 

Any ideas are greatly appreciated.

 

Thank you,

 

Rick Stevenson

 

                       
3 Antworten
  1. 3. Dez. 2013, 04:07
    Other than Lookup Filters and Visualforce, you're out of luck here!!

     

    Have to do it the old fashioned way by asking reps to comply!

     

    David