sharepoint list custom edit form show related lookup column field values

Question

I have a list, and use a lookup list to populate a drop. the Lookup list has 3 fields, plus id

In the parent list the columns pulled from lookup are
Company
Company:Address
Company:City

I can select the Company and save in New form and in the list I see the related values.

Be when I open the Edit list the fields (would be read only). only Company is there
Company:Address
Company:City

When I select the company either in New or Edit form I want to see the related values and then click save etc.

I am using a solution to created and display fields in a custom form.
https://www.markrackley.net/2013/08/29/easy-custom-layouts-for-default-sharepoint-forms/

So I think this will have to be a javascript? Example for the JSON?
I get from the parent list the company name and do api call to related list to get the value array?

I can see it but am very bad with scripting. any examples would be very helpful and appreciated.

Cindy

Answer 1

@Cindy Mello

Here're steps:

1.Create a parent list named "Company". Then create Company, Address and City columns in the list.

2.Create a list named "lookup". Then create a lookup column named "Company" in the list.

3.In the lookup list, click ribbon -> List tab -> From Web Parts -> Default New Form -> Add a Web Part -> Media and Content -> Script Editor -> Edit Snippet -> Add codes in the txt file115024-codes.txt.
4.Result:

---

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.

Answer 2

@Emily Du-MSFT
This is really helpful, thank you. The part I can't find is

the lookup list, click ribbon -> List tab -> From Web Parts -> Default New Form -> Add a Web Part -> Media and Content -> Script Editor -> Edit Snippet -> Add codes in the txt file115024-codes.txt.

Where do you find the "list tab" and "From Web Parts" section? Is this from the list page itself? If so I don't seem to have that option.
thank you.