how to show the right value stored in my db in a dropdown list

Good mornig to all,

I've this problem:

a dropdown list filled with DB table's value (i.e. world's countries)

a line in another table with a data containing a world's country previously choosen with the dropdown list (called selected_country)

I would like to have a form that has the dropdown list above positioned in selected_country

ex. I have choosen in a previous form AUSTRIA from dropdown list (filled with countries name and stored in a table called world_country)

I stored AUSTRIA in selected_country field of a table called personal_data.

When another form shows data of personal_data I would like to position dropdown list to AUSTRIA.

hoping that's clear....

Thanks for your kind help

Hi Amebacci,
​
You need to use a Debugger action in the On Load event to find the names of the two form data items then use Custom PHP to set the value of world_country to be equal to the selected country.
​
Bob

First of all thanks to both of you for your answers.
​
I try to explain better my problem:
​
first form (insert in table A) - I choose an entry of a dropdown field filled from a table of countries
​
USA
SPAIN
GERMANY
AUSTRIA
ITALY
UNITED KINGDOM
​
and I store it in a table called A
​
second form (modify table A): position dropdown field filled from a table of countries exactly in a value stored previously in table A
so that, if I want to modify country AUSTRIA, I can slide dropdown field
​
​
USA
SPAIN
GERMANY
AUSTRIA
ITALY
UNITED KINGDOM
​
In this case I choose Germany