Need Help Creating a database

[Gunnu]

Hello,

I am trying to create a database using access. I want to store the
current inventory of boxes and other moving supplies. When i sell an
item from this inventory to a customer, i want to store that
transaction and reduce that item in the inventory. How can i do this?
I am confused in setting up the relationships between the tables. I
know that i would need these table:

(1). Customer table

(2). Order table

(3). Product table

But how do i represent, for example, " A customer purchases many
products in one order" and how do i decrease those items quantity in
the product table.

Thanks,
Bharath

 

[bhicks11 via AccessMonster.com]

Hi Gunnu,

This is a pretty general questions so here is a general answer. You can
update the inventory after the sale by running an update query that decreases
the items/quantity based on the items/quantity posted. You would probably
want to run a routine that checks the quantity before selling to make sure
you have inventory and also add a pop up that let's you know when your
inventory is getting low so you can replenish.

Bonnie
http://www.dataplus-svc.com