How can I create a table in Numbers that is connected to another one?

Hi,

to come around the problem of the inexisting dynamic drop menu in Numbers, so that I can show a certain drop menu based on a previous drop menu I selected.

I thought I could create several new tables identical to the main one, filter down the rows only with a certain selection of the first drop menu, and then create a new column with a specific drop menu for each different table.

So if in the main table I selected "food" from the drop menu, in the new table, which will be filtered for only rows that contain "food", I can create another drop menu (restaurant, bar, grocery...). Likewise, if I had selected "entertainment", I'd go to a new table with a different drop menu.

The problem is that I'd like the secondary tables to show automatically the rows I add in the main one, without having to copy and paste every time.

Thanks,

Edo