Help with my Database for Orders

Haven't used access in a few years, was hoping it would all flow back, but not really happening. Maybe I never had it.

I want to build a database to track sales, customers and stock. I have 3 tables Customers, Products & Orders.

I want a form that will display a list of uncomplete orders( I think I can do this with a query and a tick box called orders complete in the orders table)

I want to be able to click on each of the uncomplete orders and display a form.

This form will display the order information ( like date order made & order complete tick etc)

Also the Customers information( Name, shipping address, email etc) I am going to but a button here that will allow me print a shipping label. (Hopefully will just be a report)

And the part I am stuck on is the product part, I want a list of about 5 or 6 dropdown boxes for adding products to the order.

I have attach a screenshot of my relationship and 2 pics I did when planning it . Hopefully with the pictures and my above description you will understand what i want to do

Hi

I want to build a database to track sales, customers and stock. I have 3 tables Customers, Products & Orders.

Click to expand...

Before you do anything else, I think you should take a look at your tables.
I could be wrong, but it looks very much to me as though you need another table for the details of each order as in the "Northwind DB"

Yes. There should be an OrderItems table. Then you can n items per order, not just three. Products table should lose the Profit column. That's derived data. There should be a ProductPrices table - different customer types get different prices, and marketing campaigns often offer special pricing. Product costs change over time for the same product, so a table for that as well. It can get much, much more complicated than this.