AnsweredAssumed Answered

Budget numbers...

Question asked by RandyHandley on Dec 25, 2016
Latest reply on Dec 26, 2016 by philmodjunk

Hi Everyone!

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!