By using this website, you agree to our Terms of Use (click here)
I am trying to create an inquiry that has the latest revision for each Projects Budget forecast. The only usable field I can use is CreatedDateTime as the revision number can be text or a number so the user can change this.
Now I am not sure how I can get this to happen as tried a few things already so asking here to see if anyone else has an idea, that will be great. Attached is my inquiry but this currently shows all revisions. Thanks in Advance 🙂
Can you add a filter to your generic inquiry to reference PMForecast.RevisionID? I have only worked with the PMBudgetForecast items in a report, but I added a parameter and filter on my report to select the revision. Because the revision field is manually entered by the user who creates it, I'm not sure if there's a way to filter automatically.
@megan-friesen Thanks..Yeh I gave up and added a custom check box so that if that was ticked, that was the forecast to use / apply to their report