SharePoint 365 Parent-Child Relationship

Shelley B 136 Reputation points
2021-07-13T13:58:12.327+00:00

Hello,

We need to set up a relationship between a parent list and child list on SharePoint 365.

For example.

When the employee is selected it automatically populates the employees Manager name

Any help would be most appreciated

SharePoint
SharePoint
A group of Microsoft Products and technologies used for sharing and managing content, knowledge, and applications.
9,533 questions
{count} votes

2 answers

Sort by: Most helpful
  1. Echo Du_MSFT 17,111 Reputation points
    2021-07-14T06:06:57.697+00:00

    Hello @Shelley B

    Please following steps:

    1.Create the first list named "Employee"

    114387-11.png

    2.Create the second list named "Manager" and create a Lookup column named "Employee"

    114453-21.png

    3.Create the third list named "Depart" and create two Lookup columns named "Employee" and "Manager"

    114386-31.png

    4.Upload the cascadingdropdown.js file to Site Assets Library.

    114379-41.png

    5.Go to the third list and switch to classic mode. On the LIST tab, click on Form Web Parts >> Default New Form.

    114406-51.png

    6.On the New Form page, click on Edit Page and add a Content Editor Web part.

    7.Edit Web part and type the url of cascadingdropdown.js to the content link box

    114380-52.png

    8.Go to the third list and switch to classic mode. On the LIST tab, click on Form Web Parts >> Default Edit Form. Refer to the “Default New Form” (6~7)for subsequent steps.

    114454-new-item.gif

    Thanks,
    Echo Du

    =============================

    If an Answer is helpful, please click "Accept Answer" and upvote it.
    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    1 person found this answer helpful.

  2. Shelley B 136 Reputation points
    2021-07-23T13:16:12.033+00:00

    Do you mean on the third list? If so, this is the employee column

    117432-image.png

    0 comments No comments