I have a database that has a unique record for multiple sizes of the same image. ? I need to reduce the size of the database by combining records together that share the same unique image where the only difference between the records is the image size (but the actual image is the same).
I need to combine database records with identical images (but different sizes) to create a condensed version of the database whereby records that have identical images (but different sizes) are combined together under a single database record that lists the alternate sizes available.
The specific steps to perform are:
1) I provide a sub-set of the total database of all records that have the same content in the Name/Title field - these are the records that in all likelihood are multiple records of the same image but listed one record per size
2) You look this sub-set of records and visually check if the Name/Title that is the same between records has the exact same image, or if the image is different
3) For those records that are duplicates (same image, same Name/Title, but the image SIZE is different), you will add the SIZE field contents to the first record in the database and mark the remaining records as duplicates
I will provide a standalone database application that contains the database records and thumbnail images and functionality to copy/paste and mark records as duplicates with a simple interface, along with a short video you can watch online that demonstrates exactly how to perform the task using the database application I provide.