Symptoms

---

Trying to set up such a way that Project managers (from pm_project field) can see timecards under timesheet > pending approvals. 

 Resolution

---

The Time Sheet table does not reference Time Card table. This can be seen in the screenshot attached.

 

 

This is the schema map of the Time sheet table and the tables it references.

Time sheet references the User table, but not Time card table. This is why the Pending approval module can add User manager, but cannot add Project manager, as this table does not have a reference field to Time card table.

A filter or a report dot-walking from the Time card table to the Project manager field can be created instead.