Please help me with the below requirement,
I am using two list items
1. Product List (Stagging List with Hierarchy)
2) Key Products(Flat List)
Ex: Having only one Product: PRODUCT A
In the Product Hierarchy list, I am maintaining one attribute called Key Product ? with the boolean format.
Now, in Product Hierarchy "Key Product?" attribute should tick. Whatever the PRODUCTs exit under "Key Product" list those list item should TRUE others FALSE.
I am using FIND ITEM Function but it's not working because the PRODUCT list is a numbered list and this list has duplicates.
Please suggest the same.
Thanks and Regards,