Thank you. This is great but I now have another challenge. I need to return the Id to update the database. With the name being returned, I cannot update the database using JSON.
The Id of the drop-down is not the same as the rowid.
Database table example
Main grid table
—————
rowid: 3
AccountId: 6 (Value from dropdownlist. This value comes from another table.)
BankName: Nedbank
BankNumber: 123456
Dropdownlist table
—————-
Id: 6
AccountName: Cash In Bank