Hello, I have two documents. One is called “Requirement,” and within it, I have a multiple select table where I select the departments authorized to fulfill this requirement.
I have another document called “Request,” where the user selects the department, and then a table is enabled. One of the columns in this table is “Requirement,” a link field pointing to the doctype “requirement.”
The idea is that users can only see the requirements related to the selected department. I’ve tried everything, but I simply can’t get the filtered list. What can I do?