I
Isis Rings
I started an online sales business about two months ago. When I began, it
was no big deal to track sales and profit on a spreadsheet. I had another
spreadsheet with contact information.
Now, however, with about 10 orders a day, tracking is getting HELLISH!!! I
am constantly switching between one spreadsheet, another spreadsheet,
outlook, and my web shop-cart program!!!
Now, I've installed access 2003, and built several tables with corresponding
forms (customers, products, suppliers, purchases, wholesale orders)
I understand how to actually create relationships, but I must be missing
what they do! I want to enter a new purchase, and with the e-mail address,
have the program auto-fill the rest of the associated fields/tables.
For example, I enter their e-mail, the program fills their first, last, and
e-mail in the same table. At the same time, it adjusts the total number of
inventory remaining. It also updates the "total purchases" and "current
purchase comments" in the customer table.
Is this possible? Or am I just dreaming that a program exists that will
actually make my life easier!!!!
Thanks for reading all of this, and thanks in advance for any help!
Kimberly
was no big deal to track sales and profit on a spreadsheet. I had another
spreadsheet with contact information.
Now, however, with about 10 orders a day, tracking is getting HELLISH!!! I
am constantly switching between one spreadsheet, another spreadsheet,
outlook, and my web shop-cart program!!!
Now, I've installed access 2003, and built several tables with corresponding
forms (customers, products, suppliers, purchases, wholesale orders)
I understand how to actually create relationships, but I must be missing
what they do! I want to enter a new purchase, and with the e-mail address,
have the program auto-fill the rest of the associated fields/tables.
For example, I enter their e-mail, the program fills their first, last, and
e-mail in the same table. At the same time, it adjusts the total number of
inventory remaining. It also updates the "total purchases" and "current
purchase comments" in the customer table.
Is this possible? Or am I just dreaming that a program exists that will
actually make my life easier!!!!
Thanks for reading all of this, and thanks in advance for any help!
Kimberly