I have a main table with two specific data columns I load into two separate drop downs in another table. In the new table, picture selecting a value and wanting to populate the adjacent cell at the same time.
In other words, I have two populated drop-down cells in a new table based off of collected column data from the main table.
I need the new table to populate the (pin cavity) value column based on the selected (pin name) value column and vice versa.
I can get each column to correctly provide the data in each drop-down table cell but they work only independent to one another.
The attached image shows how I got the independent dropdowns populated. I need to have them work together when either drop-down selection is made.
This image is the main table where the drop-down are populated from.
Can someone please help me?
Thank you!
