john said:
Hi all,
When you build an invoice from
existing data, in the invoice table
do you recopy the data or simply put a reference
to other table.
regards
In many cases both. Which you should use for specific pieces of data is
determined by asking the following question.
If I look at this invoice in the future and some of that data in the related
tables has changed, which version do I want to see?
If you want to see the data that existed at the time the invoice was created
then that data from the related tables should be copied and made part of the
invoice record. The customer's current discount rate or shipping address are
examples of data that you would likely want to copy.
If you want to see the data as it currently exists then you should just display
the related data whenever viewing or printing an invoice. The name of the
company or contact phone number are examples of data where you likely always
want to see the current data.
