I've been trying multiple solutions on the internet, but can't seem to get this to work. I have a dropdown list (secondary datasource) that shows designations. When a 'designation' is selected, the corresponding 'Hourly rate' should show in a text field. (Hourly rate comes from same datasource than designation. List is called: Budget - Designation. (I have 2 data sources to that list)
First you have to select Item type = 'Professional Fees' then you need to select the Designation, and based on Designation selected, the Rate field should populate accordingly.
The dropdown has a rule to set the hourly rate field once the dropdown field changes. It only takes the first entry and displays that in the hourly rate field, regardless of which designation you select.
My form has 2 views, the view "add new item" should have this functionality. Can someone please help to see what I'm doing wrong in my fx function?