This is very annoying as this is the second time I've had to write this post so please forgive me if am a bit economical with my words!
Anyway, I have a DB, which I've attached with 2 tables.
I have a form called items that I use to create new items and add ingredients to them.
What I want to do is to be able to add new ingredients to the items table with this sub form - this would mean that the subform would have to create new item records and also display auction price, and while we're here may as well include line price too.
I would also like to include the total price on the main item form and the profit. I have a query that displays this data but I can't get it to appear on the form.
Any help greatly appreciated.
Many thanks in advance