Allow child tables to lookup parent data even when user does not have permission to view parent.

However, I'm trying to achieve a similar thing between tables, not just for fields within a table.

Is there any way I can have a user view child table data that is based on lookups from a parent table,  even though the user doesn't have permission to view the parent? I would similarly like to have one for summary fields too.

Something like this imaginary field setting for a lookup field:

Use the access permissions above for this lookup field even if the user does not have permission to view the parent data within the parent table.

Here's my specific example.

I have a table of Orders and a table of Supplier Inventory. The Supplier Inventory is viewable by all, whereas I have restricted  viewer access on the Orders table to only those users that are involved in the Order (I don't want customers to ever be able to see other customers' orders). However, I do want to base the Remaining Stock in the Supplier Inventory off any new Orders since the last Supplier Inventory stocktake.

I have thought of a few ways to do this, but nothing seems pleasantly simple.

1. Quickbase actions to update a separate Public Orders Info table.
   1. This ends up getting complicated because the actual withdrawn quantity is based on at least 5 other tables (Deletions, variations, etc.),
2. Quickbase Pipeline to update a static Remaining Stock field based off the formulated Remaining Stock field whenever something happens in any of the other tables.
   1. Probably my best bet.
3. Open up the Orders table to be viewable to all
   1. Too risky

I'll go ahead with Option 2 in a couple of days... but would love to know if my imaginary field setting is possible... or if there's a better way to do it.