Hello,
(Apart from a very minor wrinkle)
I now have a working system.
It is probably very clunky in your eyes.
I load the first page given in the underneath URL.
That then allows Presenters to use the descendent menus to choose a new Country, Region, and City.
When they hit "Update", the ID values are placed in the fields NewCityID, NewCountryID, and NewRegion1ID.
Pressing the update button also immediately takes Presenters to the followup page (also given underneath).
That page then has 9 MySQLi scripts as follows:
UPDATE presenter_data
SET presenter_data.CountryID = presenter_data.NewCountryID
WHERE
(
presenter_data.NewCountryID IS NOT NULL);
UPDATE presenter_data
INNER JOIN countries ON ( presenter_data.CountriyID = countries.id )
SET presenter_data.Country = cities.`name`;
UPDATE presenter_data
SET presenter_data.NewCountryID = NULL
WHERE
(
presenter_data.NewCountryID IS NOT NULL);
I then repeat each of those in separate MySQLi queries for Region1ID and CityID.
This may be a long roundabout way, and it is probably more elegant with Javascript and/r Ajax, but this is now working.
Thank you.
