antp.be forum

I need a script "to cumulate" multiple records in an AMC Data Base.
I have multiple records such these:

fieldMedia = serie 1
fieldOriginalTitle = story1
fieldTranslatedTitle = thisepisode1

fieldMedia = serie 1
fieldOriginalTitle = story1
fieldTranslatedTitle = thisepisode2

fieldMedia = serie 1
fieldOriginalTitle = story1
fieldTranslatedTitle = thisepisode3

fieldMedia = serie 2
fieldOriginalTitle = story2
fieldTranslatedTitle = thisepisode1

fieldMedia = serie 2
fieldOriginalTitle = story2
fieldTranslatedTitle = thisepisode2

at the end, I would like to obtain :

fieldMedia = serie 1
fielddescription = story1 - story 2 - story3

fieldMedia = serie 2
fielddescription = story4 - story 5

no matter about other fields, my problem is to recognize "new" records from "old" so that, in a next step, I could delete "old" records.
Sorry fon my english, I understand my difficulties to explain problem but I could give you examples of "new" and "old" DB .....

Well, I think I have a good Idea:
1) I renumber records sorting them in increasing "media label & media type"
2) using a script, I cumulate "original title & translated title" in "description field" for every record with same "media label & media type" (last record with a certain "media label & media type" will contain all "original title & translated title".
3) I renumber records sorting them in decreasing "media label & media type"
4) Using a script, I clear "description field" in any record with "media label & media type" same than preceding
5) I group records by "description field" and I delete records with that field blank!!!

Does my strategy is wrong?
Any suggestion to improve it?

At the End:
I wrote two scripts to solve steps 2 and 4.
If someone is interested, I'll post them.
Happy Sunday!