I am using sharepoint 2013 and designer 2013. i have two lists "product NC(non-conformance) Detail" and "Product Status". one product have many NC# and status column option column. In Product Status list i want if product id all status resolved than "product Status" list status column update resolved. if one field unresolved than unresolved. Output shown in "Product Status". Below are two lists. Product NC Detail Prod ID NC # NC Description Status 1 1.1 Hardware test failed resolved 1 1.2 Software problem unresolved 1 1.3 etc unresolved 2 2.1 resolved 2 2.2 Hardware test failed unresolved 3 3.1 resolved 3 3.2 resolved 4 4.1 unresolved 4 4.2 resolved
Product Status Product ID Status 1 unresolved 2 unresolved 3 resolved 4 unresolved
Thanks in Advance