How to Bypass a Security Filter for a Column

[Anton_Dickens]

Hi everyone,

I have a child table "Timesheets" which has a security filter meaning employee users can only see their own timesheets, plus management users can see all timesheets.

In the parent table "Clients", I have made a virtual column [Most Recent Timesheet] where I want to be able to show the most recent date a timesheet was entered against that client, so all employee users can see that date regardless of which employee entered the last timesheet.

However it seems the security filter is doing its job, so the virtual column won't show when the last timesheet is by another employee! Is there any way to bypass the security filter for this single column?

Thank you!