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.
Thanks.
Hi kullboys,
You can keep the id saved and look up the names when you need them - that is probably the most technically correct solution.
You can look up the names after the form is submitted and replace the ids with them before saving.
You can change the way you create the options so that the name is used for both text and value.
Bob
You can keep the id saved and look up the names when you need them - that is probably the most technically correct solution.
You can look up the names after the form is submitted and replace the ids with them before saving.
You can change the way you create the options so that the name is used for both text and value.
Bob
This topic is locked and no more replies can be posted.
