AnsweredAssumed Answered

Returns a list of box # all containing an item in a search

Question asked by dennisbuitelaar on Oct 26, 2016
Latest reply on Oct 27, 2016 by beverly

Hi,

 

I would to write a script that returns a complete list of box numbers containing the same item but also shows other items in these boxes.

 

Shipment     Box #    Item   

A                  123        abc

A                  123        def

A                  456        klm

B                  478       abx

B                  478       lan

B                  479       ghi

C                  501      abc

C                  501      cuz

 

When searching for item "abc" I want a list of box numbers returned including all items, so return find should be box # 123 and 501

A                  123        abc

A                  123        def

C                  501      abc

C                  501      cuz

 

Anyone able to help?

 

Thanks,

Outcomes