Dynamic Functionality of Table

I want to have two tables, Table A display some columns A,BC,D grouped by account numbers, and then table B display Coloumns E,F,G. I want to know can I select one row in Table A in such a way that TABLE B automatically filters for account numbers? This can be done in POWER BI but what is the way to do this in streamlit?

I believe this can be done, last time I check streamlit’s table is smarter.

Can you please explain how?

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.