Hi Lesley You write:
"I don't need a program that edits as I have Affinity for that, so just a photo file management system I can use in conjunction with Affinity Photo is what I need. I use Windows. "
May I suggest: TotalCommander as file management, Yes I know it is an old dos application, but it has proved its superior capacity through the years. You can do all the tasks You want, copy, move, delete rename. You name it Total Commander has it. It works perfect in windows. It was created many years ago by Peter Norton, (as Norton diskdoctor) the first to develop programs to help us beginners.
As a preview app, i use the "Faststone Image Viewer" it is free, but you can pay a small sum if You want. In Fasttone Image Viewer, yoy can view 4 images at a time, magnified to 100 - 200 prct. This give You the possibility to select the images to keep, and thos not.
This is just my suggestion, I use these two apps to manage my approx, 40.000 images
Hope You find what You are looking for, and please forgive me if i make mistakes in english, i am danish. 😀
Best regards Poul West