Notes
In Salesforce, an object can have up to two master-detail relationships, meaning it can act as the child (detail) in two different master-detail setups. However, it can only be the parent (master) in one master-detail relationship.
This limitation is important when designing your data model, as it affects how objects can be linked together. Proper planning is essential to make the best use of these relationships and ensure your design meets business requirements efficiently.