Results 1 to 2 of 2
Thread: Tracking sales (Access 97)
2004-02-24, 23:27 #1
- Join Date
- Jul 2003
- Oakland, California, USA
- Thanked 0 Times in 0 Posts
Tracking sales (Access 97)
(Subject edited by HansV to be more descriptive than 'Access')
(Thanks very much! Tabitha)
I am trying to modify an existing database so that I can track how much of what product a customer has bought. I tryed to do this with a Wizard which created a "Sales" type database, but I don't understand how it works, so I can't change it to do what I want. Either I need to copy something someone else has made, or I need a step-by-step tutorial that addresses this issue.
The product list numbers about 40 and products are continually being added, and retired. We give 10 free to a department of certain things, and then start charging, but I have to track the inital 10 items.
Any and all help greatfully received.
2004-02-25, 12:26 #2
- Join Date
- Jun 2001
- Crystal Beach, FL, Florida, USA
- Thanked 33 Times in 33 Posts
Re: Tracking sales (Access 97)
The basic design of this database would require 3 tables. A Customer table, a Product table, and a Sales table.
The Customer table would have CustomerID, CustomerName, etc.
The Product table would have ProductID, ProductName, etc.
The Sales table would have CustomerID, ProductID, etc.
The Sales table is the "many" table in 2 one-to-many relationships, with both the Customer and Product tables. Therefore, to specify a Sale record, you need to know the Customer and the Product.
If you have a form for Customer entry, you can add a subform based on the Sales table. This would show you all sales to that Customer.