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 user saying "Corresponding Task is open for this requirement. Please complete the open task in order to complete requirement."
Is it possible?