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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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
|
|||
|
|||
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 | |
|
|