Transaction Table

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?
 
A

Armen Stein

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.
 
Top