Finally seem to have fixed it .

(Think it was a rogue line in my file that was imposing restrictions in some tables and not others. I put it inside an if statement so it was imposed only on those tables and that seemed to do it.)

I'm so happy to have fixed it as its been annoying me for months and I had thought it was something to do with my table not being indexed correctly or being corrupted.