In order to achieve what management wants, I'd image i'd need to place Opportunitie as the Primary object, and set the B relationship as Program (because not all opportunities have programs YET, and we are trying to identify that)
The custom object is set as Deployed, and is allowed for reporting (which is why we can use it as a primary)... What is preventing Programs from appearing from the B relationship dropdown list?
3 answers
HI Steve - The way your objects appear in Custom Report types is based on the relationship type between your objects. I'm assuming you the relationship between Programs and Opportunities is a Lookup Relationship.
Additional information: https://help.salesforce.com/articleView?id=relationships_considerations.htm&type=5
