Cascading of Lookup Dropdown Fields on SharePoint 2013 and Office 365

Welcome to an article on the ‘Cascading of Dropdown fields on SharePoint 2013 & Office 365’. This is a major approach when we build forms and when we have to use multiple look up fields on the form and they should be related to each other as a parent and child relationship.

So what happens is, when you select a parent, other child items are related to it. So if you select a particular parent, all the child items related to the parent will appear.

Let’s see it.

  • Create a list named “Company”.Click on Add an app,

  • Choose the Custom List App

  • Click on it and create a ‘Company’ List.

  • Once the list is created, add in the names of the companies.

  • As per the screenshot below.

  • Create another list named as “Employee

  • Once the list is created, Create a look up column named as Company from our Company List.

  • As you can see below, Clock on Create Column and the choose Lookup.

  • Select the list as Company and choose the Title field while configuring the lookup column.