Transaction Table

  • Thread starter Thread starter JS
  • Start date Start date
J

JS

My business has many deposits and withdrawls to post each
month. Should I use one transaction table, or should I
use a deposit table and a withdrawl table with a jumper
table connecting the two?
 
Works either way, but the one transaction table will be more efficient.
Click to expand...

I agree with Allen - you can just have a Transaction table that holds
all kinds of transactions, positive and negative.

If you do go with two tables, you can use a UNION ALL query to mix the
two types together. This will be handy when you want to sort them by
date, for example.
 
Back
Top