I've got a lookup column that is pulling another field with it. I am trying to show the other field on a New form when a selection is made from the lookup dropdown.

The user needs to use use this information to make a choice on whether or not to suggest a modification.

How can I pull back the associated information with that lookup selection?


You can't do that out of the box.

If you put some JavaScript on your NewForm.aspx with a Content Editor Web Part or Script Editor Web Part and use JQuery and the SPServices library from Codeplex (https://spservices.codeplex.com), you can do this fairly easily.

This is an example from the Codeplex site:

columnName: "System",
relatedList: "Systems",
relatedListColumn: "Title",
relatedColumns: ["System_x0020_Image", "Lead_x0020_Sales_x0020_Rep"],
displayFormat: "list"

This displays the fields "System Image" and "Lease Sales Rep" from the Systems lookup list when the field "System" is changed. The value selected in the System field is looked up using the Title field in the Systems list to find the data.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.