+ Start a Discussion
BAGELBAGEL 

What the different between Master-Detail Lookup Relationship and Normal Lookup Relationship?

As the subject said, what's the different and when to use which?
MicaiahFMicaiahF
This may answer both this post and your next post. 

SFDC- Overview of Object Relationships
https://na1.salesforce.com/help/doc/user_ed.jsp?section=help&loc=help&target=overview_of_custom_object_relationships.htm&body=%2Fhelp%2Fdoc%2Fen%2Fhelp2.jsp&hash=topic-title

In short to create a related list of one object in your custom object you would need a master-detail relationship. 

Unfortunatley, products is less agile than other objects and is not available as a master relationship for custom objects, possibly for any object other than Opportunities.  You may consider creating the relationship to the Opportunity.

Micaiah
BAGELBAGEL
So does that mean if I want to create a custom object to replace Opportunity, there is no way I can add products to my new custom object?
MicaiahFMicaiahF
Saying "no way" is always a stretch for me.  There is likely some API capabilities you could employ to interact with the data.  That would be a question for someone with more knowledge than me. 

I know there is not a simple way to tie products into a custom object.

Hope this helps.

Micaiah