Well I was looking at a different way of doing it because nothing was working!!
PLus the inventory is easier to manage by splitting into seperate tables. I was looking at thhis website http://www.fontstuff.com/access/acctut10.htm and was looking at the Multiple row source table and I...