Filter Table Records Based on Linked Record Fields

USE CASE: Tracking lifecycle deployment of reusable medical devices through calibration, put-away, order planning, picking, shipment, allocation to surgical kits, and return for calibration.

I am using linked records to associate individual serialized product with pick lists (for sending replacements for deployed devices which are nearing their calibration expiry) and also for shipments that are en-route and/or pending receipt / allocation into surgical kits.

I was hoping I could exclude devices from my table query results which are already linked to an existing shipment or in-progress pick. Seems I would have to parallel the content of the link field in my tables into a parallel table field for this to work.

It would be much simpler to be able to filter the table query to exclude any records where the linked field IS NOT BLANK (i.e. that record is already linked).