Action Button to Open a Reference Subtable

2

It’s possible to add filter attributes to the URL.
pql for fuzzy search
pqv for exact match

You might be able to generate a URL with you as attribute for Filtering the results.
if Job# field ID is 1234567
then you can use:
[url for Sheet B]?pql1234567=a
to open entries of Sheet B that matches Job# = a

As described in this post.