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.