Ok. Any help would be greatly appreciated. Here it goes. I have a small business running and I need to make a database which stores my materials (unique code,..., price). Now this is easy even for me. The problem is that I need to find a way how to create Products (table I assume) which keeps track of which materials are needed to make it. The other thing I need is, to have access calculate the total price of the materials needed to make that product (sum of mats*quantity).

So bottom line would be, I have my mats defined, I need to enter a new product with certain set of mats and their quantities which need to be all calculated in the end to get the price of my product.

I understand this is asking a lot, but I am struggling to make this damn database and the only solution I see is forums or taking a tutorial course. Thank you in advance. Back to work :confused:

have not look at this but what you are going to need is continous forms - and under stand these

and a greater understanding of PK and FK
PK primary Key#
and Foreighn Keys