Help with an Order Entry Database

[3239]

I am new to access and I am trying to created a database for orders placed by customers and for inventory purposes.

What I am trying to accomplish is lets say I have three tables, one called Purchases by Customers, one called Inventory, and one called Ordering. And if I order 12 bars of soap, I want the Inventory table to show 12 bars of soap, and if a customer orders 2 bars of soap, I want the Inventory table to be updated to 10 bars of soap, and if I order 3 more bars of soap, the Inventory table will be updated to 13 bars of soap.

If this is possible, could someone please help.

 

[KenReay]

Hi

It is perfectly possible, but the answer is longer than it is reasonable to give here. To begin you almst certainly need more than three tables eg without even thinking about it:

PurchaseOrderHeader
PurchaseOrderDetail
SalesOrderHeader
SalesOrderDetail
Inventory
Customers
Suppliers
Products

as I said more than three

Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[GingerR]

hint: refrain from using spaces in object names (tables, queries, forms etc) or field names. it's not illegal, just a possible pain in the butt later.