Only show data which has a matching value

I’m sure this is something simple but,

How can only show data which has a matching value without losing the ability to add new data
(see photo) I need ‘signature sheets’ filtering by ‘job number’

Thank you

Are you able to use Job number as a key value? Then it would show you just those signatures that are related to your job.

Not really,

The key value for the client remains the same, lots of other sheets link to it, where as the ‘Job number’ changes for each new job. was looking for a filter.

Then create a slice with the Job number filter and use that slice as a source for a new virtual list column (using RefRows as well).