I have a simple database for keeping my checkbook (or all finances)
straightened out. and i am looking for suggestions on how to make my deposits
splittable..

i have two simple tables

T_Transactions
TransactionID
TransactionDate
TransactionAmount
TransactionDescription
ExpenseCategoryID

And
T_ExpenseCategory
CategoryID
CategoryName
IsTaxable

when i enter a deposit the bank statement only shows one amount but it may
actually be the sum of 6 checks all needing different categories assigned to
them..

Does anybody have any neat ideas about how to setup a database that can do
this.
I know the basics pretty good but im not sure if i can figure out a good
user interface for this.. or how to maintain good normalization if one
transaction has no split details while others have many split details.. I
remember years ago using quickbooks and there was a split button that sent
you off somewhere.


Any ideas would be greatly appreciated..

Thanks
Barry