I have 1 Requirement list and 1 Tasks list with InfoPath 2010 forms.
- Tasks list having Lookup column as of Requirement Title field.
- Both lists having Status field.
When user save Requirement (InfoPath form) with Status=Completed
I want to check whether there is any corresponding tasks exist in tasks list with Status != Completed
.
if so I want to show a message (or form validation) to the user saying
"Corresponding Task is open for this requirement.Please complete the open task in order to complete the requirement."
Is it possible?