OK here’s another tanners worth.
Your spending far too much time mucking about with tables, relationships, and forms.
The answer is in queries and reports.
Take a look at this. I think this may be what you are trying to achieve.
I'm not going to give it you all at once 'cause you wont learn...