Help with my Database for Orders

[stephencaso]

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

 

[bob fitz]

Hi

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

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"

 

[bparkinson]

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.