Make reference field dependent on choice field

[Singh1]

Hi everyone,
I am stuck in a scenario where I need to show certain values based on one field. So, my scenario is:
I have 2 fields, 1 being string with 3 choices and other one being reference which acts like a choice field which has 14 records.
On selection of 1 field (Theme) I want to show certain values on other field (reason). I have set up a reference qualifier and it does work but it works only upon saving the record, but my current scenario wants me to change the values of the reason field once the theme field value changes before saving the record. Can anybody help me with some basic code or some logic that I need to follow for this?
Thanks

[JenniferRah]

If there are only 14 records, could you change your Reference field to a string with drop down field? Then you can use the first field as a dependent value for the choices in field 2. Look at Category and Subcategory on Incident for an example of this.

If that's not possible, can you send a screen shot of your reference qualifier? Because that should be evaluated as the first field changes, not on save.

[Ankur Bawiskar]

@Singh1 

When it's a new record you might be passing the field value to reference qualifier which is not available in current object and hence it won't work

you can have 2nd field as choice with 14 values and then show/hide the options

That's the only way

If my response helped please mark it correct and close the thread so that it benefits future readers.

[Ankur Bawiskar]

@Singh1 

Hope you are doing good.

Did my reply answer your question?

If my response helped please mark it correct and close the thread so that it benefits future readers.