如何从与第二个列表中的数据相关联的第三个列表中获取数据以显示在主列表中 [英] How to get data from a third list associated with data in a second list to display in a primary list

问题描述

我有三个列表:供应商，课程和会话.卖方全年分多次提供课程.  使用Sharepoint 2013，我正在使用查找字段将供应商与一门课程关联，然后将一门课程与一个或多个会话关联.

但是，在会话"列表中，我正在手动输入供应商的公司名称.我想弄清楚如何在会话列表"视图，显示"表单和编辑"表单(可选)中选择课程"后，如何自动填写供应商的公司名称 具有查找控件的标题.  只有在保存表单后，才能填充此内容.参见下图:

我的限制包括我不是SP管理员并且没有SharePoint Designer访问权限.  我的工具集仅限于在InfoPath和/或Nintex中创建的表单.

谢谢

解决方案

根据您的要求，您可以使用级联下拉列表对InfoPath进行此操作.

或者，您可以使用JavaScript代码来做到这一点.

有一个有关级联下拉列表的博客，您可以参考它:

https://parallelmindsblog.com/2012/12/17/cascading-drop-down-list-in-sharepoint-2010/

谢谢

Wendy

I have three lists: Vendor, Course and Session.  Vendors deliver courses in multiple sessions throughout the year.  Using Sharepoint 2013, I am using lookup fields to associate the Vendor to a course and then a course to one or more sessions.

In the Session list, however, I am entering the Vendor's Company Name manually.  I want to figure out how in the Session List View, Display form and Edit Form (optional) I can get the Vendor's Company Name to auto-populate after I select the Course Title with the lookup control.  This could even be populated only after saving the form. See the diagram below:

My constraints include that I am not a SP administrator and don't have SharePoint Designer Access.  My toolset is pretty limited to forms created in InfoPath and/or Nintex. 

Thanks

解决方案

Hi,

For your requirement, you can use cascading drop-down lists to do that with InfoPath.

Or, you can use JavaScript code to do that.

There is a blog about cascading drop-down list, you can refer to it:

https://parallelmindsblog.com/2012/12/17/cascading-drop-down-list-in-sharepoint-2010/

Thanks,

Wendy

这篇关于如何从与第二个列表中的数据相关联的第三个列表中获取数据以显示在主列表中的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！