I need a junction object to link my account to the custom object offer and promotion. Since both of the custom objects are related to pricing, I was wondering if I can create a pricing package junction object, and depending on the record type selected, the user can link to either offer or promotion. Would that make sense? Tia.


This would not work because you can only have up to two master-detail relationships on an object. You cannot have three (one to Account, one to Offer and one to Promotion).

You could have two lookup relationships to Offer and Promotion instead, but the result would no longer be a junction object. Maybe this works for your requirements or maybe you have to create two junction objects.

| improve this answer | |

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.