List Parts/Price

[DaveB]

Could you tell me if there is a way to do what I'm trying
to do in access. I'd like to create a table or form or
whatever that will list parts and prices. They need to be
related to my customer table. I need to have it so that I
can have many parts with their respective prices, and
have differnt quantities for each different customer. For
instance one customer my need 100 parts, while another
might need 3 parts. I'd like it to be able to add up the
total prices at the end. Is there a way to do this, and
how?

 

[Howard Brody]

What you need are four tables:

tblCustomers - your master list of customers with their
CustID, name, billing and contact information, etc.

tblItems - your master list of all items carried with
their ItemID and any other appropriate information

tblCustomerItems - the list of items used by each
customer, listing the ItemID, CustID, Price and any other
information individualized for each customer.

tblCustomerOrders - the list of orders and items ordered
by customer, listing OrderID, OrderDAte, CustomerID,
ItemID, Quantity, DateShipped, etc.

To get your dollars or outstanding (unshipped) orders, you
just need to build some simple queries or reports.

Hope this helps!

Howard Brody