SharePoint lookup field cascade implementation (by infopath)

The advantage of inforpath implementation is that you do not need to write code, but the disadvantage is that the form style will change after the release. The following describes how to implement infopath:

I. First, you need to prepare three tables. Table 1 is a device type table that stores device type information:

Table 1

Table 2 is a device table that stores device information. The device type field is of the lookup type and points to the title field in table 1:

Table 3 contains the device application form and the application information. Both the device type and device name are of the lookup type and point to the title fields in Table 1 and Table 2 respectively.

Cascade options not implemented

2. After the table is ready, you can start setting infopath.

In the device application form List, click "custom form ". The browser must use IE; otherwise, infopath cannot be opened.

Create a data acceptance connection after entering infopath.

Enter the website address of the list:

Select Table 2:

Select related fields:

In the infopath form, right-click the device name control and choose properties:

Select the data connection just created for the Data source:

The Set Value and display name correspond to the ID and title fields respectively. Modify the attributes of the item:

Click to filter data:

Add filter conditions:

After adding the data filter, save the expression and publish it. In table 3, add a project to view the effect:

 

Final Effect

 

Although code is not required to implement cascading in infopath, after the form is published, the page style of the website changes to the style in infopath. I have not studied the causes and solutions, you are welcome to add some experienced users. I hope you can share some other convenient implementation methods. You are welcome to point out something wrong in this article. Thank you!