0

The number of Lookup relationship that an object can have are as in today ?

0

Master-Detail Relationship Fields, per Object (Standard or Custom) --> 2

Total Relationship Fields (Master-Detail + Lookup), per Object (Standard or Custom) --> 40

Its Like,

38 Lookup and 2 MD

39 Lookup and 1 MD relationship fields on an object

Please check this link:

https://success.salesforce.com/answers?id=9063A000000DYD0QAO

  • This answer can be improved by adding a link/source. – Pranay Jaiswal Sep 11 '18 at 9:52
  • ok so it means object can have 38 lookup relationship? – Darshana Sep 11 '18 at 9:56
  • you can have all 40 as Lookup Relationship fields.Please check my updated answer – Annappa PH Sep 11 '18 at 9:57
  • @Priya 40 is not a hard limit, though. You can request more with a valid business purpose. For example, we currently have 46 in our production org for Account records. – sfdcfox Sep 11 '18 at 10:37
2

By default, the system is limited to 40 lookup fields per object, up to two of which may be master-detail relationships if it is a custom object. You can request more than the 40 relationship per object limit if absolutely necessary, although there are performance implications for doing so. The absolute limit that you can request is 50.

0
                     **Considerations for Relationships**

Relationship Limits

Each custom object can have up to two master-detail relationships and many lookup relationships. Each relationship is included in the maximum number of custom fields allowed.

  • The Total relationship field included lookup can be 40 by default. As @sfdcFox said, it can be increased if needed by raising a request to salesforce up to 50.

Earlier it was 25, after Summer ’14 Release, The default number of Relationship Fields per object has been increased, from 25 fields to 40 fields.

enter image description here

reference:-

  • Your answer isn't quite correct, but it isn't incorrect, either. There is a way to request more than 40 fields if you need them. – sfdcfox Sep 11 '18 at 10:41
  • Thanks, @sfdcfox I need to mention your words too in my answer. – sanket kumar Sep 11 '18 at 10:54

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.