| Author | Thread |
|
|
03/08/2010 01:05:54 PM · #1 |
Is there anyone here that can make an easy workflow database for me?
I would like the ability to track Customers, Products, and Orders. I would like to have buttons to make new entries for each of the 3 categories listed below. And actually if you can just work some of your magic I want to make this almost dummy proof and as simple as it can be.
Customers:
"a picture of them"
First Name
Last Name
Address
City
Zip
Phone
all orders ever placed > and the ability to see the products for each order
a running Total of amount ever spent
a running total of Discount amount
Products:
Name of product
Product ID
Cost of Product
Fabric Color
Orders: (I'm thinking, make this look like an invoice)
Order #
Date of order
Name of customer
Product Desc.
Quantity
Rate
Amount
Tax
Total
personalization info
personalization color
personalization style
|
|
|
|
03/08/2010 03:50:08 PM · #2 |
Okay I have created the DB in MS Access 2007 but I need some help linking some of the fields together and displaying information from another table.
Can anyone help me with that???
|
|
|
|
03/08/2010 03:53:31 PM · #3 |
| ok - I'll give you a hand. I'm PM'ing now... |
|
|
|
03/08/2010 03:57:48 PM · #4 |
Fixed a few things;
Originally posted by Dirt_Diver:
Customers:
CustomerID (numeric identity column)
"a picture of them"
First Name
Last Name
Address
City
Zip
Phone
all orders ever placed > and the ability to see the products for each order <-- not stored on this table, this is calculated
a running Total of amount ever spent <-- not stored on this table, this is calculated
a running total of Discount amount <-- not stored on this table, this is calculated
Products:
ProductID
Name of product
Cost of Product
Fabric Color
|
Orders are split into 'Order Header' and 'Order Detail' - In order detail you store the order lines for each order. The header hold everything together, and links the orders back to the customer. For example;
OrderHeader
OrderNumber
CustomerID
OrderDate
Status
Paid
Quantity
Rate
Amount
Tax
Total
OrderDetail
OrderNumber
LineID
ProductID
Product Desc.
Quantity
Rate
Amount
Tax
Total
personalization info
personalization color
personalization style
You need to get the structure right before you think about designing forms etc. What I'll say is that it might be worth your while to look at a simple bookkeeping program, which will do all of this for you.
|
|
|
|
03/08/2010 04:00:09 PM · #5 |
okay thanks, JH I will adjust and Art I will call you in a min.
Also I do have quickbooks but this is all for my wife. She runs a small thirty-one business and she needed something small, and cheap to keep a track of customers more or less.
I may look into it though
Message edited by author 2010-03-08 16:02:44.
|
|
Home -
Challenges -
Community -
League -
Photos -
Cameras -
Lenses -
Learn -
Help -
Terms of Use -
Privacy -
Top ^
DPChallenge, and website content and design, Copyright © 2001-2025 Challenging Technologies, LLC.
All digital photo copyrights belong to the photographers and may not be used without permission.
Current Server Time: 08/24/2025 04:09:55 PM EDT.
