Hi All,
So I know a little bit about access but not heaps and I have to create a database etc for work….so hoping anyone can help me out with my question below in regards to table setup…..with idiot proof answers please
Ok so if I have a table that lists all my raw materials for example (sugars, salts, flavourings etc) and a table that lists all my products example: (Mars Bar, Snickers, Kit Kat etc), what is the BEST WAY to set my tables etc up to:
- list all the materials that exist in the product (could be 50+ for each product)
- and also the other way, list all the products that a material is used in
So that I can then create a query that says “show me all the materials that are used in Mars Bar”
And also a query that says “show me all the products that 104.0003 malted sugar is used in”
The materials have an ID that is the primary key so that’s their unique identifier (104.0001, 104.0002, 104.0003 etc) and the products have their codes that are their primary key and unique identifier (MB, KK, SK etc)
There is over 400 materials.....
I have just used the materials & products as an example…I don’t actually work for Cadbury or Mars….just used them…so sorry, no free chocolate haha
Thanks everyone in advance