After several attempts, I can not figure out how the select dropdown property works when you want to save the selected item into a table. Let’s say that I have a very simple table named Companies, with a field varchar named Province. Then I have another table called Province that lists all the Province names.
What I do is that I set up a form with a select element and I link it the a server connection that does the query in the Province table. In this way I have the select pre-populated with all the province.
The problem is when I try to save the selected Province in the varchar field of the Company table.
There is no way to update the province name. In the same form there is also an input field to update the company name and it works perfectly. The problem comes up only with the select form.
Any help is appreciated. I have read any possible threat and watched so many video. I understand that most of you are developers and probably this is a question for very beginners but I could not find any tutorials specific on this topic. Many thanks
Last updated: