I now have a database which works properly, I googled around and found out how to make these. For others searching, this video I found sums it up nicely:
(Not allowed due to low postcount, on youtube search for 'Access 2007 Tutorial 1.3. Many to Many Relationship' by djdates)
Thanks for...