G
Gary Dolliver
Hi all,
I am hoping for some help on this one, as I am baffled and in a crunch. I
have inherited some funk data that has come to me in a strange format. It is
a single table full of multiple orders, however, each order takes up at least
3 or more records in the table. There are no distinguishing or identifying
fields to link these together, however, in field 1, there are only three
fields that break apart the orders, /SOHDR (order header info), /SOLI (line
item info, sometimes there will be more than one), and /SOSUM (order summary
line). There is nothing to link these together as an order, I can only go
off of the order that they appear in the table.
What I am wanting to do is to take a field from the /SOHDR field and insert
it into the next /SOSUM record (for the corresponding record) and then
perform this for the next /SOHDR and /SOSUM records. I was thinking I could
create some type of function, or would an update query work?
Please help, thanks!
-gary
I am hoping for some help on this one, as I am baffled and in a crunch. I
have inherited some funk data that has come to me in a strange format. It is
a single table full of multiple orders, however, each order takes up at least
3 or more records in the table. There are no distinguishing or identifying
fields to link these together, however, in field 1, there are only three
fields that break apart the orders, /SOHDR (order header info), /SOLI (line
item info, sometimes there will be more than one), and /SOSUM (order summary
line). There is nothing to link these together as an order, I can only go
off of the order that they appear in the table.
What I am wanting to do is to take a field from the /SOHDR field and insert
it into the next /SOSUM record (for the corresponding record) and then
perform this for the next /SOHDR and /SOSUM records. I was thinking I could
create some type of function, or would an update query work?
Please help, thanks!
-gary