A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

does this make sense



 
 
Thread Tools Display Modes
  #1  
Old April 5th, 2010, 10:52 PM posted to microsoft.public.access.tablesdbdesign
Nicolette
external usenet poster
 
Posts: 2
Default does this make sense

Ok i'm going to try to explain this as simply as possible.
database purpose: I sell italian charms and makeup on ebay and other auction
sites. I am making a database to track my invenotory (which is massive)
track auction listing for each product, track sales of each product, track
customers and I use the mailmerge to create invoices, packingslips, and
labels in word.

I have the forms to add the inventory, to add the listings, to add
customers, etc. but what i want to do if possible is to on a weekly basis
have access automatically create the invoices, packingslips, and labels and
attach each invoice to the customer but it must be able to follow this
hierarchy
CustomerID
InvoiceID
SKU Title Qty UnitPrice Total
SKU Title Qty UnitPrice Total
As many times as needed for the order
** These don't really have to be listed vertically they can be
horizontal like a table but they need to be for that specific invoice **
Subtotal
SalesTax
ShippingCarrier ShippingCharge
Discount
InvoiceTotal
And then for the second Invoice for the same customer
InvoiceID
SKU Title Qty UnitPrice Total
SKU Title Qty UnitPrice Total
As many times as needed for the order
** These don't really have to be listed vertically they can be
horizontal like a table but they need to be for that specific invoice **
Subtotal
SalesTax
ShippingCarrier ShippingCharge
Discount
InvoiceTotal

I have a report to display this but i need someway to put all this together
in a table I think... I'm not sure....

What do you all think? I was thinking the way to go would be to create a
table in a seperate database for each customer but that would be beyond
massive...

I would appreicate any ideas or suggestions
Thanks So Much!!!!

Nicolette
  #2  
Old April 6th, 2010, 07:38 AM posted to microsoft.public.access.tablesdbdesign
Nicolette
external usenet poster
 
Posts: 2
Default does this make sense

Anyone?

"Nicolette" wrote:

Ok i'm going to try to explain this as simply as possible.
database purpose: I sell italian charms and makeup on ebay and other auction
sites. I am making a database to track my invenotory (which is massive)
track auction listing for each product, track sales of each product, track
customers and I use the mailmerge to create invoices, packingslips, and
labels in word.

I have the forms to add the inventory, to add the listings, to add
customers, etc. but what i want to do if possible is to on a weekly basis
have access automatically create the invoices, packingslips, and labels and
attach each invoice to the customer but it must be able to follow this
hierarchy
CustomerID
InvoiceID
SKU Title Qty UnitPrice Total
SKU Title Qty UnitPrice Total
As many times as needed for the order
** These don't really have to be listed vertically they can be
horizontal like a table but they need to be for that specific invoice **
Subtotal
SalesTax
ShippingCarrier ShippingCharge
Discount
InvoiceTotal
And then for the second Invoice for the same customer
InvoiceID
SKU Title Qty UnitPrice Total
SKU Title Qty UnitPrice Total
As many times as needed for the order
** These don't really have to be listed vertically they can be
horizontal like a table but they need to be for that specific invoice **
Subtotal
SalesTax
ShippingCarrier ShippingCharge
Discount
InvoiceTotal

I have a report to display this but i need someway to put all this together
in a table I think... I'm not sure....

What do you all think? I was thinking the way to go would be to create a
table in a seperate database for each customer but that would be beyond
massive...

I would appreicate any ideas or suggestions
Thanks So Much!!!!

Nicolette

  #3  
Old April 6th, 2010, 06:02 PM posted to microsoft.public.access.tablesdbdesign
Fred
external usenet poster
 
Posts: 1,451
Default does this make sense

Hello Nicolette,

As note by your followup, I noticed that nobody answered. For someon to try
to answer, there are two big issues right from the start:

Your question s really hundreds of question, and some of them are in two
areas (inventory and invoices) where the business-process-defining and Access
work are amongst the largest and toughest.

Second, in order for someone to start trying to help you you will need to
describe the specifics of the process that you want to database. You
skipped this whole "useful infromation" part and skipped to providing not
useful information (your ideas in a few areas on structure).

This is a big project that you are embarking on. If you are willing to
spend a year of work and learning to get it done as a way to learn databasing
and Access more, then that's fine. If not, you might be better off looking
at some (small scale) enterprise softwar which would do all of those things.
..
  #4  
Old April 6th, 2010, 06:20 PM posted to microsoft.public.access.tablesdbdesign
Stephen Raftery[_3_]
external usenet poster
 
Posts: 9
Default does this make sense

It seems to me that a report is the most appropriate way to do this. You say
you already have a report for your weekly printout: in what way is the report
you have made not up to the task?
I really think that creating a separate database for each customer would be
very much over the top and counter-productive.
In what way does the report not work?


Stephen



"Nicolette" wrote:

Ok i'm going to try to explain this as simply as possible.
database purpose: I sell italian charms and makeup on ebay and other auction
sites. I am making a database to track my invenotory (which is massive)
track auction listing for each product, track sales of each product, track
customers and I use the mailmerge to create invoices, packingslips, and
labels in word.

I have the forms to add the inventory, to add the listings, to add
customers, etc. but what i want to do if possible is to on a weekly basis
have access automatically create the invoices, packingslips, and labels and
attach each invoice to the customer but it must be able to follow this
hierarchy
CustomerID
InvoiceID
SKU Title Qty UnitPrice Total
SKU Title Qty UnitPrice Total
As many times as needed for the order
** These don't really have to be listed vertically they can be
horizontal like a table but they need to be for that specific invoice **
Subtotal
SalesTax
ShippingCarrier ShippingCharge
Discount
InvoiceTotal
And then for the second Invoice for the same customer
InvoiceID
SKU Title Qty UnitPrice Total
SKU Title Qty UnitPrice Total
As many times as needed for the order
** These don't really have to be listed vertically they can be
horizontal like a table but they need to be for that specific invoice **
Subtotal
SalesTax
ShippingCarrier ShippingCharge
Discount
InvoiceTotal

I have a report to display this but i need someway to put all this together
in a table I think... I'm not sure....

What do you all think? I was thinking the way to go would be to create a
table in a seperate database for each customer but that would be beyond
massive...

I would appreicate any ideas or suggestions
Thanks So Much!!!!

Nicolette

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:03 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.