Jaime,
Take a look at his:
Table to Table to Table relationships with Lookups and Summary fieldsFollowing this architecture will allow you to view all of your records within the support tickets table. You would want to lookup the status of your project to your phase table and then lookup the statuses of project and phase to your support tickets table. Then you could create a formula field to return "open" if all three statuses are not "closed" otherwise return "closed".
In this manner, your delegate would not need to run a report, but only navigate to the support tickets table and apply the dynamic filter. Likewise, you could easily create a report with the same filter applied and add that to a dashboard or as a link in an email notification.
Here is what it looks like:
Here is the formula used for the overall status:
If([ID - Status]= "closed" and [ID - Status2]= "closed" and [Status] = "closed", "closed", "open")
------------------------------
Adam Keever
------------------------------
