Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Invoicing

Status
Not open for further replies.
dominicgingras

dominicgingras

Technical User
Jul 15, 2002
53
CA
If you had to desing an invoicing system with two table:

table1 = general information
table2 = Details for the invoice

Would you store the invoice total in table1 or calculate that total everytime you need it?



 
Sort by date Sort by votes
My (and probably not other people's) advice: never store results that can be retrieved by calculation...

HTH
[pipe]
Daniel Vlas
Systems Consultant
danvlas@yahoo.com
 
Upvote 0 Downvote
How would you store the total in your first table?

On what event would you attach the code?

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

iuianj07
  • Locked
  • Question
Invoicing Module -- count number of completed tasks 1
2
Replies
36
Views
209
iuianj07
iuianj07
bigfigkid
  • Locked
  • Question
Order/Invoicing Question
Replies
3
Views
62
sillysod
sillysod

Part and Inventory Search

Sponsor

Back
Top