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...
A friend of mine has a disease which causes him to get nauseus when eating certain products. We know which products these are and sadly we regulary find new products which cause this (severe) nausea. I wish to help this friend by making a database of all products and ingredients so that we might...