I have a custom object name Loan__c and it has the relationships below to the Opportunity object
- Lookup relationship from Opportunity to Loan
- Lookup relationship from Loan to Opportunity
On the Loan__c object, I have a filed name
Uncollectable_On_Receipt__cIs there a way to display the "From Stage" and "To Stage" fields on a report that is created from the Loan__c object?
The only way I could display the "From Stage" and "To Stage" fields is when I create a report using the the Opportunity History Report Type, along with the Uncollectable_On_Receipt__c?
Regards,
5 answers
+1 Jackie
Forrest - you could be in for a long haul having lookup relationships going both ways here. You would be much better off using a Junction Obect
https://help.salesforce.com/HTViewHelpDoc?id=relationships_manytomany.htm&language=en_US
if your goal is a many to many relationship. The way you have it set up could quickly turn into a reporting nightmare
