each code is an expense code, and for certain expenses, for example kilometres, it is necessary to multiply the amount entered by 0.45. (gas)
is there a way to set up a formula so it only effects one code within the table and not all of them?
A look up field from the table Expenses, where you choose the code and enter other information, looks up info from the Codes field in the Expense code table.
How do I create a formula so when km is chosen in the expense code look up field, it then autimatically knows to multiple the amount of kilometres entered by 0.45?