I am attaching an ERD of the client's organization, specifically the objects involved in the Apsona Grid I am trying to create. The client currently has a Conga Grid that we are attempting to recreate in Apsona Grids. The Conga Grid can pull in fields from the Opportunity object; however, the Apsona Grid does not appear to allow access to the Opportunity object.
The Apsona Grid is being created/starting from the Tribute Acknowledgement object. There are approximately six Opportunity object fields that need to be displayed on the Grid, but I cannot access any of these fields from the objects currently available on the Grid (screenshot attached).
Should the Opportunity object be available in this case? Is there another step that I am missing? By starting from the Tribute Acknowledgement object, I can access the Tribute Gift object. From the Tribute Gift object, there is a lookup to the Opportunity object, but this lookup relationship is NOT available via the Grid.
Please let me know if you have any questions or if I can provide clarity on any of the statements above.