Looks like you need this relationship for that second occurrence:
ArtistGalleries::_fkArtistID = ArtistPhotos|Gallery::_fkArtistID AND
ArtistGalleries::_fkGalleryID = ArtistPhotos|Gallery::_fkGalleryID
In your portal to ArtistPhotos, you can set up ArtistPhotos::_fkGalleryID with a value list for selecting the gallery currently showing that photo.
Thank you very much Phil for your quick reply. I think I'm still getting something wrong. Did you mean:
I create a second occurrence of the ArtistPhotos table, call it ArtistPhotosGallery and then link it as you suggest to the ArtistGalleries Table? I did this as you can see in the image. In the portal to ArtistPhotos as you suggest I set up a value list for selecting the gallery which does seem to all work fine. What eludes me still is that I'd like to display the gallery name in full and not just the ID in the portal. I did what has worked until now which is just to tell a field show "GalleryName" from the GALLERIES table however when I select the right gallery from teh drop down list in one field, this last mentioned field does not change accordingly...
Might you have any tips please?
If you link an occurrence of Galleries to ArtistPhotos by galleryID fields, you can use fields from this new occurrence in your portal row to show the Gallery name or any other data about the Gallery showing that photo. You might not need to do this if you set up your galleryID field in the portal as a popup menu.
Thank you Phil for being such a help - it all works now and I can end my day with a mini sense of triumph as it really was bugging me. Such a simple solution, but I just wasn't getting it, I really do appreciate your experience and help thank you. Great things these forums!