Hi. what I mean by "relationship code" is this. a relationship between
transactions. Here is a sample of what I have and need.

Have

PO Item Type Material Number MvT Pstg date
12345 10 NB 789 101 1/6/2009
12345 10 NB 789 321 1/8/2009
12345 20 NB ABC 101 1/7/2009
12345 20 NB ABC 101 1/7/2009
12345 20 NB ABC 321 1/8/2009
12345 20 NB ABC 321 1/8/2009
56789 60 NB A1A 101 2/4/2009
56789 60 NB A1A 321 2/5/2009
56789 90 NB AAA 101 1/13/2009
56789 90 NB AAA 101 1/13/2009
56789 90 NB AAA 101 1/13/2009
56789 90 NB AAA 101 1/13/2009
56789 90 NB AAA 101 1/13/2009
56789 90 NB AAA 101 1/13/2009
56789 90 NB AAA 101 1/13/2009
56789 90 NB AAA 321 1/16/2009
56789 90 NB AAA 321 1/16/2009
56789 90 NB AAA 321 1/16/2009
56789 90 NB AAA 321 1/16/2009
56789 90 NB AAA 321 1/16/2009
56789 90 NB AAA 321 1/16/2009
56789 90 NB AAA 321 1/16/2009


Need

PO Item Type Material Number MvT Pstg date Code
12345 10 NB 789 101 1/6/2009 1000
12345 10 NB 789 321 1/8/2009 1000
12345 20 NB ABC 101 1/7/2009 1000
12345 20 NB ABC 101 1/7/2009 1001
12345 20 NB ABC 321 1/8/2009 1000
12345 20 NB ABC 321 1/8/2009 1001
56789 60 NB A1A 101 2/4/2009 1000
56789 60 NB A1A 321 2/5/2009 1000
56789 90 NB AAA 101 1/13/2009 1000
56789 90 NB AAA 101 1/13/2009 1001
56789 90 NB AAA 101 1/13/2009 1002
56789 90 NB AAA 101 1/13/2009 1003
56789 90 NB AAA 101 1/13/2009 1004
56789 90 NB AAA 101 1/13/2009 1005
56789 90 NB AAA 101 1/13/2009 1006
56789 90 NB AAA 321 1/16/2009 1000
56789 90 NB AAA 321 1/16/2009 1001
56789 90 NB AAA 321 1/16/2009 1002
56789 90 NB AAA 321 1/16/2009 1003
56789 90 NB AAA 321 1/16/2009 1004
56789 90 NB AAA 321 1/16/2009 1005
56789 90 NB AAA 321 1/16/2009 1006

The code can be anything. I just used 1000. This way, I can export to
Access and then get the information I need. Can someone assist me?

Thanks