Hi Everyone.
I am creating an invoicing program in access 2012. Here is what I need your help with to continue. I want a master table with everything i sell. Lets say I sell widgets. I have 20 customers that buy these widgets, but each customer pays a different price for the widget. When creating an invoice and I make a repeat sale of the widget to a customer, I want to show the date and last sale price to that customer for the widget. I also want to be able to change the raw cost of the widget in the master table, and it will automatically update each customers price using the same % of markup.
My questions is should each customer have an individual sales history table, or should sales history for all customers be in one table sorted by customer number.
Thanks for your help everyone!!
Keith