Skip to Content
0
Former Member
Jul 26, 2016 at 08:52 AM

Selection formula to choose between 5 data fields

28 Views

Good day

i need some help with a selection formula to select description from 5 different tables. once a user selects a transaction i need the formula to match it with the correct subledger and then using that it gives the description as of that subledger.

i.e.

Purchase order - description

inventory control - description

General ledger - description

Accounts payable - description

so if the transaction is coming from purchase order it should select the description as per the purchase order