combine records

[JCAA]

I am trying to find out how I can combine some of my records in my table. There are a few items that have been updated and have a new part number. I want to combine their sales history while leaving other fields such as description intact. For example if I have a record called 1234 and another called 1234A I want to call it 1234A and add the total sales history for 1234 and 1234A to the “new” 1234A both 1234 and 1234A did have the same description so I want to leave that intact.
Does this make any sense?
All help appreciated!

 

[Tomadams]

I have done this by using two new fields titled 'supercedes' and 'supercededby' I use these to maintain an audit trail through different part numbers. I then write my queries and reports to track these fields.

 

[smitan]

You might also solve this by having an external PartNumber=1234 or 1234A and an internal PartNumber, which might be a autonumber.
Then you do not have to struggle with thiss, as the 'old' partnumber can be changed anytime.

Success
Hans