Talk About Network

Google


Register and Login
Nick
Password
Register create new account Sign up is FREE and you can post replies, new topics, bookmark posts and more!
Recover lost password


Data Bases > Microsoft Access > Is this an acce...
Latest [ Topics | Posts ] Archive Post A New Topic Post a Reply
<< Topic < Post Post 1 of 2 Topic 30527 of 31576
Post > Topic >>

Is this an acceptable way to design an accounting, purchasing set of

by jmDesktop <needin4mation@[EMAIL PROTECTED] > Jun 16, 2008 at 03:06 PM

For an accounting / banking database, I have the following in a two
transaction tables showing what someone spends or credits:

Transaction Table //one only
--
TransactionID
UserID


TransactionItemID Table  //many
--
TransactionItemID
TransactionID
ItemID


AccountTable //one to one from TransactionID Table
--
AccountID
TransactionItemID
UserID
Debit
Credit
Balance


One transcation, many items tied to that single transaction.  Results
of that transaction put in the account table.  Is this right or too
many tables?
 




 2 Posts in Topic:
Is this an acceptable way to design an accounting, purchasing se
jmDesktop <needin4mati  2008-06-16 15:06:58 
Re: Is this an acceptable way to design an accounting, purchasin
Roger <lesperancer@[EM  2008-06-17 03:31:22 

Post A Reply:
  Go here to Signup

AddThis Feed Button


About - Advertising - Contact - Frequently Asked Questions - Privacy Policy - Terms of Use - Signup

Contact
tan12V112 Tue Dec 2 23:16:17 CST 2008.