Using 2 tables. First table feeds the second. When dropdown value selected I would like the other table to populate automatically



I have two tables. The first is a master table with columns. The second table is a single row table with a drop down in column 1 where I clear on entry and add items to create the dropdown. I would like to know how in the 2nd table upon selection in dropdown to pull in the field values for the other fields in that given row.