Reply to thread

Message

<blockquote data-quote="HappyTalk" data-source="post: 137493" data-attributes="member: 22671">In a mad fit of generosity today I coded the 2 functions you need in my Tools script. You can get it here <a href="http://forum.antp.be/phpbb2/viewtopic.php?p=22701#22701" target="_blank">http://forum.antp.be/phpbb2/viewtopic.php?p=22701#22701</a> .There's 2 files ensure both are saved in the ANT scripts subfolder (cut and paste to notepad then save using the names above each code block)First make a backup copy of your ANT database. Now select all your records, go into scripts window and 1) Run UpdateTools script and use the 'Append Fields' function to copy from the 'Number' field to the 'Media Label' field. 2) Run UpdateTools again and use the&nbsp; 'Renumber Records' function to renumber all your records sequentially. I've tested it all out and it will rearrange your database in no time. If you've already gone through the pain of doing it manually alas I am too late....cheers</blockquote>

[QUOTE="HappyTalk, post: 137493, member: 22671"] In a mad fit of generosity today I coded the 2 functions you need in my Tools script. You can get it here [url]http://forum.antp.be/phpbb2/viewtopic.php?p=22701#22701[/url] .There's 2 files ensure both are saved in the ANT scripts subfolder (cut and paste to notepad then save using the names above each code block) First make a backup copy of your ANT database. Now select all your records, go into scripts window and 1) Run UpdateTools script and use the 'Append Fields' function to copy from the 'Number' field to the 'Media Label' field. 2) Run UpdateTools again and use the 'Renumber Records' function to renumber all your records sequentially. I've tested it all out and it will rearrange your database in no time. If you've already gone through the pain of doing it manually alas I am too late.... cheers [/QUOTE]

Verification