i have 3 list. Input list, reference table list and transfer. list. I want to remove all related entries in reference table if a certain product is chosen
example reference table product a - category 1 product a - category 2 product b - category 1
so if i go to the input list and added product a - category 1 in the list, what i would like to do is remove all "product a' from the reference table and copy to transfer list, then delete them from reference table. I tried creating a workflow but only the current list is deleted from. the reference table.