need help with an inventory database

[neerajam]

tblingredients consists of the following fields:
ingredientid: number
ingredientdescription: text
amountinformulation: number (%)
compoundid: number

I have another table called tblschedule. Consists of the following fields:
compoundid: number
noofbts: number
batchweight: number
qtyingredientrequired: number

THe end result that I wanted was to join the 2 tables on compoundid and obtain the qty of ingredient required for each compound, each ingredient by multiplying amountinformulation * batchweight * noofbts.

I did this as query but the error message I got an error message not updatebable. Any one got any suggestions on how to proceed. Thanks in advance.

 

[sammar76]

Try a create table query, and then manipulate the new result.