M
Miranda
Hi,
I have created something similar to a ledger database that tracks invoices.
I have 4 tables thus far - Account types, Budget Revision Amounts,
Planned_Budget and Invoice_transactions.
The table I need to modify is Invoice_transactions, this table will list the
invoices to date. Every invoice is matched to a account. So you enter the
amount of the invoice the date and what account it belongs to.
Now what I need to do is for every invoice I need to add information as to
where the money came from. It can come from a max of 4 places or min of 1.
For ex. An invoice of $1000 is taken off the equipment account. Then I
need to specify where the money came from, grp1 $250.00, grp2 $250.00, grp3
$250.00 and grp4 $250.00.
Should I create another table with the groups and how much money each group
has, then reference it to the invoice_transactions table. I also need a way
to add or subtract money from each group on a continous basis.
Any help would be appreciated.
I have created something similar to a ledger database that tracks invoices.
I have 4 tables thus far - Account types, Budget Revision Amounts,
Planned_Budget and Invoice_transactions.
The table I need to modify is Invoice_transactions, this table will list the
invoices to date. Every invoice is matched to a account. So you enter the
amount of the invoice the date and what account it belongs to.
Now what I need to do is for every invoice I need to add information as to
where the money came from. It can come from a max of 4 places or min of 1.
For ex. An invoice of $1000 is taken off the equipment account. Then I
need to specify where the money came from, grp1 $250.00, grp2 $250.00, grp3
$250.00 and grp4 $250.00.
Should I create another table with the groups and how much money each group
has, then reference it to the invoice_transactions table. I also need a way
to add or subtract money from each group on a continous basis.
Any help would be appreciated.