Dynamic Functionality of Table

Selecting a single row and returning the value at a given column say account number, check this post.

Once the account number is identified, you can use it to filter values in Table B.