A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Suggestions to Split Transaction details



 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old April 2nd, 2010, 10:32 PM posted to microsoft.public.access.tablesdbdesign
Barry A&P[_2_]
external usenet poster
 
Posts: 119
Default 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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:10 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.