merging files

[Martin McCaffery]

At 5:53 PM -0400 6/10/08, James Cook wrote:
>The place to start is to merge them all together, then sort the field
>with the titles. Use the Math menu to UnPropagate the field, which
>will empty duplicated names and leave just one of each. Select those
>that are not equal to "", meaning literally empty and Remove
>Unselected.



Only do this IF each title is unique.

You should look at the DB's and see if there is some unique 
identifier. A station generated code or just the CD's label's id#. 
Being a radio station it is quite likely they have singles songs as 
well as albums, so duplicate titles are likely. Not to mention all of 
the various re-releases (I have at least 5 different versions of This 
Year's Model).

And, of course, load all of the DB's into a new DB before 
experimenting, so you have the originals. You may have to do some 
rearranging and adding of fields, depending on how consistent the 
various DB's were kept over the years.

Once you have things normalized, Panorama will zip right through it.