New Record #Error

[mithani]

use query, that will make your life easier.

 

[chefdaveross]

Im not sure how to query that.

I tried :

=Sum(IIf(IsNull([RecipeItemID]),0,(NZ([ItemAmount]*[txtRecItemPrice]))))

in the subform footer and getting #error

how can i query so total shows on main form?

 

[mithani]

I have noticed that your Item table has Item_ID and table TblTecipe has RecipeitemID. Are they different? If same, than should have same name else you can't creat any relation.

 

[chefdaveross]

Yes those are different Id's

ItemId is for the food item such as asparagus

RecipieId refers to the recipie such as beef stew
which is used in RecipieName table not shown

I can upload it if that helps