So I have two database called: Project Management Portal (aka PMP) and Serenity.
In Serenity I have a listing of titles. In PMP I have 'work orders' that are linked to these titles. So essentially when we need some sort of action done for a title, a work order is created to name the task. This works fine and dandy.
What I am struggling with is that I want some of the PMP fields to show in Serenity to trigger a report. Both have a cross application share and I have done a relationship between two of the tables but I can't get the PMP information to automatically show up on the record in Serenity
How can I get that information to appear in a report? Basically I am trying to create a report that says "show me all the titles that are marked as an APPROVED title that had a work order completed within the past week on it"
Any help is appreciated