Unanswered: Advice needed to create an order processing database
I am an a level student and my (first) project is to create a database that can process orders. I am very new to Access and i'm struggling a bit and really need some advice.
I've created my tables and relationships with no problems. I'm now trying to create the form to input a new order. This is where i'm stuck. What i've come up with is not working as i want it to.
So far, i've got a query that has the order_id, products, price, and it calculates the discount, VAT, and totals. I've then got a datasheet form created from this query - this is my subform.
The main form i've set up to allow the client information and order number and shipping address to be input. The main form and subform are linked with the order_id.
The totals for each product ordered, and other calculations, are showing on the subform correctly, but i don't how to get a field on the main form that shows the total amount for the entire order, i.e. to add the totals for each of the products selected. I don't even know if what i've done so far is right or if there's a better way i can achieve what i need.
I've spent hours going through the text books i've got and i'm still none the wiser. I've attached a zipped copy of the database so far because it's difficult to explain, and it may help to actually look at what i've done so far incase anyone can help.
I use WinZip 9.0 and when I try to extract the file it says:
skipping: OMS - Copy.mdb this file is not in the standard Zip 2.0 format.
Please see WinZip - Unsupported Zip Format for more information.
Version required to extract this file is 63.
Compression method required to extract this file is 14
error: no files were found - nothing to do