Forums

Hello, I have a dropdown that reads the data from the REGION table and returns the data ID and NAME and another CITY table that is related to its REGION.In the database, only the ID of both tables is saved, because this ID is the data-value.I need the NAME field to be saved instead of the ID, how can I solve this problem?
Thanks!

Hi shadowgun1102,
​
You can use the Name as the value in the dropdown as well as for the text; or
​
You can look up the Name(s) from the IDs before the DB Save action; or better
​
You can continue to save the IDs and look up the names when you need them.
​
Bob

shadow the third option is the right answer and you should to that.