I have a very complex opportunity detail page. There are nine related objects, all with their own tabs. Three of those related objects are joined to the Opportunity via join objects. Two of those objects are working fine, but this third object isn't.
What I'm trying to do is to display in a table data from the related object, not the join object. Our opportunity is a Loan, and the three related objects are Borrowers, Properties, and Title Reports.
Borrowers are a record type of Account, and are joined to the opportunity via the Borrower Join custom object. My BorrowerAccount model has a condition of Account ID is in the BorrowerJoin model's Account field. The BorrowerJoin model has a condition of Opportunity lookup field is in the Opportunity model's ID field. On the Borrowers tab I can display data from the model BorrowerAccounts, and directly edit the accounts.
Properties are a custom object, related to opportunity via the PropertyJoin custom object. My Property model has a condition of Record ID is in the PropertyJoin model's Property lookup field. The PropertyJoin model has a condition of Opportunity lookup field is in the Opportunity model's ID field. On the Properties tab I can display data from the model Property, and directly edit the properties.
Title Reports are a custom object, related to opportunity via the TitleReportJoin custom object. My TitleReport model has a condition of Record ID is in the TitleJoin model's TitleReport lookup field. The TitleJoin model has a condition of Opportunity lookup field is in the Opportunity model's ID field. On the Title Report tab I cannot display data from the model TitleReport - I can only display data from the TitleJoin model.
Any ideas why a third data model set up the same way would fail?
What I'm trying to do is to display in a table data from the related object, not the join object. Our opportunity is a Loan, and the three related objects are Borrowers, Properties, and Title Reports.
Borrowers are a record type of Account, and are joined to the opportunity via the Borrower Join custom object. My BorrowerAccount model has a condition of Account ID is in the BorrowerJoin model's Account field. The BorrowerJoin model has a condition of Opportunity lookup field is in the Opportunity model's ID field. On the Borrowers tab I can display data from the model BorrowerAccounts, and directly edit the accounts.
Properties are a custom object, related to opportunity via the PropertyJoin custom object. My Property model has a condition of Record ID is in the PropertyJoin model's Property lookup field. The PropertyJoin model has a condition of Opportunity lookup field is in the Opportunity model's ID field. On the Properties tab I can display data from the model Property, and directly edit the properties.
Title Reports are a custom object, related to opportunity via the TitleReportJoin custom object. My TitleReport model has a condition of Record ID is in the TitleJoin model's TitleReport lookup field. The TitleJoin model has a condition of Opportunity lookup field is in the Opportunity model's ID field. On the Title Report tab I cannot display data from the model TitleReport - I can only display data from the TitleJoin model.
Any ideas why a third data model set up the same way would fail?
Jack Sanford, Champion
-
10,612 Points
Posted 5 years ago
Rob Hatch, Official Rep
-
45,308 Points
Jack Sanford, Champion
-
10,612 Points
