Makes absolutely zero sense.
Agreed with Bruce, doesn't seem to make a lot of sense.
In your 'Accounts' table will you have multiple records with account code 731200?
And in the 'Ledger' you want to have just one record with account code 731200 and it should sum from the Accounts table?
reformat turned on:
Fields: Code | Account Name | Budget
Account Name: Shoes
Fields: Total Spent Shoes | Budget Shoes
I am trying to have the budget amount for a certain code show up in a field in the ledger.
my thoughts are the IF but that seems to turn out a huge number and not what is already in the record.
Accounts: Code =731200 then Ledger: Budget Shoes = $20,000.00
There is a global field in the ledger where I insert a code; I called it gAccountCode.
When I insert 731200 into it I want the Budget to be displayed.
Create a relationship going from gAccountCode in Ledger to Code in Accounts and display the now related Budget field.
Usually a ledger has one record for each transaction. A running total can show the total spending and compare that to a budget total from a related table to show whether or not spending is within budget.
Is that an accurate analysis of what you want?
If so, then one key question: what's the relationship between accounts and budget amounts? Do you have multiple accounts to a given budget or multiple budgets to a given account or both?
in other words: can more than one account be used to buy shoes? Can transactions in one account buy more than shoes? Are both possible?