Orders Management Database in Microsoft Access

[Guest]

I am somewhat new to Access and I work for a large corporation in which I key
in all the direct sale orders for our company. I am wanting to use the
Access Orders Management Database to store all my orders and I've started
using the Access 2003 template for Orders Management.

My problem is I need to know how to track the orders once they are in there.
I need to be able to enter my own customer number, my own item numbers with
descriptions, my own customer p.o., and a reference number if possible. So
when I want to find a particular order by customer number, I can go it and
pull up all orders by specific customer numbers or reference numbers, etc.

 

[Guest]

You need to modify (use design view) the Customers table, and add in the
customer number. Then you will have to modify the queries that use that
table, and drag the new CustomerNumber field to the bar, so that it shows up
in the queries. Then you will go to the forms that you want this new field
to show up in, and modify those forms (based on the queries that you have
modified). Use View/Field List to get the listing of fields, and then drag
CustomerNumber over to your form. May have to move other things around,
depending on where you want it to be on the form.

To see which queries use the Customers table, you can right-click on the
table name "Customers" and select Object Dependencies. This shows you which
Queries, Forms, and Reports look at the Customers table.

Repeat this process for any other fields you want to add.