Customer Invoice Strategy

[ChuckColeman1812]

I would like some input/thoughts. The application I'm developing has an order entry function. After an order is input, it needs to create a customer invoice. No big deal. My Invoice Report has a section where the customer name, address, state, etc is shown and a Detail section where the product purchased, price, discount, etc. is placed. No big deal. The issue I would appreciate help/your thoughts on is that the customer wants at any time in the future to pull up a customer and click on a button to see previously created invoices. I could use a continuous sub-form to show invoice dates but I'm struggling with how to reconstruct the detail of every previously created invoice that currently is generated "on the fly." Please give me your thoughts on how to do this.



Thanks,

Chuck

[RuralGuy]

Most systems like this require the historical data so values are not deleted. You need to save how much you charged or the tax at the time so another table is in order here for the history.

[orange]

There is a data model here that may be useful to you.
http://www.databaseanswers.org/data_...ices/index.htm