Hello,Not sure what the right way to do this…I have a CHILD drop down (City/Town) being populated by a master drop-down (State), all driven from a flat table, that contains all data for each States City/Towns as well as Latitude and Longitude data.On an user profile Edit page, Once the user selects the City/Town, I’d like the Lat and Long data (from the same row id) to be added to the lat and long text (read-only) fields on the same screen, and stored with in the users table. (The end-goal is I’d like to do lat-long searching later on, in the user table)Not sure how to drive this, (event?), or if there is a way to add it to the Child-field/Parent field settings of the 2nd drop-down.Any suggestions would be appreciated.Thank you,
B
Please post your tables schema and your Fields setup for more discussion.
My users table consists of (relevant fields)
id, name, country, state, city, latitude, longitudeCountry, State and City are dropdown selectors that are driven by the table below (select the country, it then filters to only show states within that country, select the state, and then only cities are loaded in to the cities dropdown list)My world_data table consists of (relevant fields)
id, country, city, state, lat, long
Example data
1, US, Akutan, Alaska, 54.143, -165.7854 1
2, US, Cold Bay, Alaska, 55.1858, -162.7211 1
3, US, False Pass, Alaska, 54.8542, -163.4113 1
4, US, King Cove, Alaska, 55.0628, -162.3056 1When the user is editing their own data (in user table), they can select (from a drop down list with parents filters, the country, state, and city.
The City dropdown list is driven/filtered by the State dropdown. All this works well.
I’d like to copy the ACTUAL VALUES of the lat and long, from the world_data table into the latitude and longitude of the user table, after the user selects city from the dropdown selector and presses SUBMIT.I hope that is clearer,Thank you!
B
bkay wrote:
I’d like to copy the ACTUAL VALUES of the lat and long, from the world_data table
into the latitude and longitude of the user table, after the user selects city from
the dropdown selector and presses SUBMIT.Just enable “Auto fill” option from “Lookup Table” pane that belongs to the “city” field of your user table, and then select “lat” for “latitude” and “long” for “longitude” from “Source Field (Lookup Table - world_data)” column.
mobhar wrote:
Just enable “Auto fill” option from “Lookup Table” pane that belongs to the “city”
field of your user table, and then select “lat” for “latitude” and “long” for “longitude”
from “Source Field (Lookup Table - world_data)” column.Thank you! Exactly what I was looking for!