does this make sense

[Nicolette]

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

 

[Nicolette]

Anyone?

 

[Fred]

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.
..

 

[Stephen Raftery]

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