Need some help to understand for currency field use in ref in one of my application

[Amandeep39]

I am using a currency code field that references values from the fx_currency table. However, when I save the form, the currency code is not retained—the field value disappears and is not visible after saving.

Could someone please suggest why this might be happening and what configuration or issue I should check in this case?

Can anyone suggest I wanna keep the selected currency code in the form, then what kind of changes are required?

[Ankur Bawiskar]

@Amandeep39 

it seems you are trying to Refer to that table while creating the dictionary?

did you try creating dictionary in normal way from sys_dictionary?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏

[Amandeep39]

I tried using a reference field, and I also verified the dictionary configuration for that field, but it still doesn’t work or retain the value. I’m looking for guidance on the underlying structure of the currency table, as I believe understanding that may help resolve the issue. I need the code field from the fx_currency table using reference, but in that table code field is not a unique one. Have a look

[Ankur Bawiskar]

@Amandeep39 

I didn't get your question

-> you are able to create a reference field pointing to fx_currency table

-> what is not retained?

💡 If my response helped, please mark it as correct ✅ and close the thread 🔒— this helps future readers find the solution faster! 🙏