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.
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.