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