SharePoint 365 Parent-Child Relationship

Shelley B 136

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

Witte, Jillian M 0 Reputation points

2023-07-23T12:26:15.16+00:00

I know this is an old solution but it worked wonderfully except for one major exception, when i want to delete just one item, all of the other 'children' delete too. I tried changing the list settings for the lookup columns to but the other children still disappear when i just want to delete one item on the target list. Is there a solution?

Thank you!

2 answers

Echo Du_MSFT 17,116 Reputation points

2021-07-14T06:06:57.697+00:00

Hello @Shelley B ，

Please following steps:

1.Create the first list named "Employee"

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

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

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

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

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

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.

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.
Please sign in to rate this answer.

1 person found this answer helpful.
Shelley B 136 Reputation points

2021-07-14T10:03:06.63+00:00

Thanks @Echo Du_MSFT

I've followed your instructions but when I select the Employee the Manager doesn't populate. Its like the script isn't running :(

Echo Du_MSFT 17,116 Reputation points

2021-07-14T10:59:47.21+00:00

Hi @Shelley B ,

It only works in classic mode, not modern mode.

Thanks,
Echo Du

Echo Du_MSFT 17,116 Reputation points

2021-07-16T07:50:13.953+00:00

Hi @Shelley B ，

Is there anything else I can help with regarding this issue?
You can comment us at any time and we will continue to follow up.

Thanks,
Echo Du

Shelley B 136 Reputation points

2021-07-16T08:03:11.093+00:00

Hi EchoDu-MSFT

Its not working in classic mode for me.

Echo Du_MSFT 17,116 Reputation points

2021-07-16T10:34:28.127+00:00

Hi @Shelley B ，

Are you create the same name of lists and columns as mine?

If not, you need modify the below code script:

#The value in [ ] needs to be modified HillbillyCascade({ parentFormField: "[Employee]", //Display name of field from parent list childList: "[Manager]", //List name of child list childLookupField: "[Title]", //Internal field name in Child List used in lookup childFormField: "[Manager]", //Display name on form of the child field parentFieldInChildList: "[Employee]" //Internal field name in Child List of the parent field });

Thanks,
Echo Du

Echo Du_MSFT 17,116 Reputation points

2021-07-20T02:16:13.107+00:00

Hi @Shelley B ，

Would you tell me whether your issue has been resolved or have any update ?
I am looking forward to your reply.

Have a nice day!

Thanks,
Echo Du

Shelley B 136 Reputation points

2021-07-20T08:31:20.377+00:00

Hi @Echo Du_MSFT
I
I used the same names for 'Employee' and 'Manager'

Echo Du_MSFT 17,116 Reputation points

2021-07-23T08:13:04.373+00:00

Hi @Shelley B ，

Please check the internal display name of the column is correct?

Thanks,
Echo Du
Sign in to comment
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
Please sign in to rate this answer.

0 comments No comments
Sign in to comment