The WideRange Galleries software enables you to add one photo to multiple galleries.
This is very simple to do when you add or modify a photo: in the "Associated Galleries" column, just click the checkbox next to each gallery you want to include the photo in.
If you later decide to remove the photo from a certain gallery, just modify the photo and unclick that gallery. You should also make sure that that gallery is not also selected as the primary gallery for the photo.
Note that if you follow the above method, you should never have to upload a photo to the database twice.