How to autopopulate a field when a drop down field value is selected

Question

I need to auto populate a filed when a drop down value of another field is selected.

For example , I have a list like this :

Bank                     Number 

Unicredit Bank           445565
Banca Italia             345689

Then I create a list where I have a form with a drop down field values of bank from the list above an a text box field number.

When a value is selected , for example Unicredit,I want the field number to be autopopulated with the value associated to Unicredit...

How can I do this ?

Flat Banana · Accepted Answer · 2017-03-30 13:40:00Z

Cascading forms is where you need to start and Mark Rackley has a great write-up and youtube video on how to set it up.

Upload the script below to our Site Assets Document Library
Upload the script below to our Site Assets Document Library
Create the “Parent” list used as a Lookup field on our form for the cascading drop down list
Create the “Child” list used as the Secondary Lookup field on our form that has a lookup to the “Parent” list.
Edit the script to point to the correct lists and fields for the Drop Down list
Edit the default New Form for a list
Add a Content Editor Web Part to the Form
Link the Content Editor Web Part to the script we uploaded in Step 1

1 Answer 1