SharePoint 365 Parent-Child Relationship

Question

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

Your answer

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!

Answer 1

Echo Du_MSFT 17,316

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.

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,316 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,316 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,316

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,316 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,316 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

Answer 2

Shelley B 136

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

Share via

SharePoint 365 Parent-Child Relationship

2 answers

Your answer