If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Suggestions to Split Transaction details
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 |
Thread Tools | |
Display Modes | |
|
|