I'll try to make this short and to the point.

Our db has a table just for our purchase orders. Sometimes we have mistakes on an order and a customer complaint is created. In the process of correcting some complaints, we need to create a new order that will ship the corrected items.

The issue is trying to link the original order to the new order. The two issues I ran into were that 1) I don't know how to link different records together from the same table and 2) the only field that are common in both orders is the PO #.. but there's a catch, the PO # in the corrected order has an "&" in the front.

e.g.
Order      Net      PO
10000      $1000      22222
10001      $1000      33333
10002      $500       &22222

Is it possible to connect order 10002 with order 10000?

Thank you.

Thanks for the reply.

I want to have all orders grouped in GH1 and have their corresponding order (that contains the & in the PO) listed underneath, either by GH2 or a sub group?