Automatically add & delete rows in Table B based on data in Table A

[distressednewbie]

Good day, fellow Excel experts. I'm in need of some help.

Below are two sheets in the same workbook, Experiment List and Iteration Times. I would like to make it so that when I add or delete a row in the first table, it should dynamically reflect onto the second table automatically.

If you are familiar with SQL, the first table's primary key is Experiment ID, which is the foreign key of the second table.

The user should not need to manually add or delete rows on the second table. It should adjust its rows dynamically based on Experiment ID in the first table.

Important Note: I do not have an issue making the Experiment ID in the second table take reference from the first table (I did this with a simple ='Experiement List'!B15). Although, if you have a better approach it would be much appreciated. I am struggling with the automatic adding and deleting of rows in the second table, based on actions done in the first table.

First table's name: Table_Main
Second table's name: Table_Iterations

 

[Fluff]

If you convert the Iteration table to a normal range you can use

=Table_Main[Experiment ID]