as everybody knows ,in salesforce we use lookup relationship when we want to relate multiple parent records to the child record. can any one give me some examples about this kind of relationship? thanks beforehand
I suspect there may be some confusion here. Multiple parents typically applies to when there are parents that are
different objects from one another. When that happens, you'll have a
ParentObjectName__c field on the child record for each object that the child record has a lookup relationship with.
Now, if you're asking about multiple parents from the same object, that's a very different story. It's something that can become quite unwieldy to manage which is also probably best avoided where possible. In that situation, ideally one would use custom lookup fields for each parent record as in
While these relationships can frequently be identified through queries using the "parent-child" relationship, it would be impossible to do that when there are multiple related parents for an object as that query expects to only find a single parent.
What you describe would more likely be a case of having multiple related records as in
ObjectRecord__r, which is perfectly fine to have.