Here is what I am trying to do.... but cant seem to figure it out.
Table: Accounts Fields: Code, Account Name, Budget
Record 1 Code: 731200, Account Name: Shoes, Budget: $20,000.00
Table: Ledger 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
I hope this makes sense!
Any help would be great!