OK I have tried to take the advice given (thanks for giving it) and change the database table structure, I have linked the tables into MS Access and drawn the links in the MS Access diagram (it is not showing the 1 to many connections etc but I think they are obvious enough). Is this design better? -

Thanks in advance 🙂