If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Help with Creating a Database.
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 |
Thread Tools | |
Display Modes | |
|
|