New to Access

[jimd1768]

I hope someone can offer help and tips as i try to learn.
I have 3 tables to start with.
1. tblcustomers - holding all customer info - primary key - cust ID
2. tblproducts - with details of products for sale - primary key - product ID
3. tblcustomer orders - primary key - Order number

I have the customer table populated & products. I have created a relationship between customers & orders via customer ID in both tables.

Do i need to add product id to my orders table. I want to be able to input a customer order and each order is then held in the customers record. I need to track how much they spend and how often, and what they buy.

I know this is a bit vague but any help would be appreciated.

Thanks in advance.

 

[gemma-the-husky]

you probably need two orders files

an order header file, identifying the order no, customer , date etc

and an order detail file identifying the order no, and the products/qtys prices. In this table you need to store the product key, to get the relationship you want

this should then able you to build a system, but you might then find (depending on the nature of your business) that you need to be even more fancy with general price files/special price files etc/discount rate files/vat rates files (generally zero rate/standard rate which may change)

good luck

 

[jimd1768]

Thank you. I may be back for help