Hi all,
In a Bill record Expenses and Items > Expenses subtab, I need to dynamically link a new Custom Column Field (Activity Code - as seen in the attached screenshot) to whatever the user selected as the Category.
[ATTACH=CONFIG]n414583[/ATTACH]
The Category field is obviously the list of Expense Categories (Setup > Accounting > Expense Categories). This is unchanged. What I need to do, is dynamically link my Activity Code column to show a drop-down List/Record based on the user's Category selection. For example, if I have the following 2 Expense Categories and linked Activity Codes (an Other Custom Multiple Select Field):
| Category | Activity Code |
| 1 | abc, def, xyz |
| 2 | xyz |
If the user selects '2' from the Category, then the only option that should be displayed in my Activity Code drop-down should be 'xyz'. If the user was to select '1' from the Category, then the 3 Activity Codes should be displayed.
Any ideas how I can achieve this?
Thanks in advance,
Kirk.