Hello everyone!
I would like to make some textboxes auto populate values (from list 2) based on a dropdown menu input (from list 1). list 1 is a general one which includes a column "car type", list 2 has details about the car types.
Ex: car type= Nissan (from list 1)
(color= black
engine power = 500cc
acceleration = 100 km/h in 10 sec) from list two.
any tips would be helpful. Thank you in advance.