I have a doc type with 3 fields.
name and city have 2 separate custom table to update them.
I want to have that when u create item in NUMBER custom table,
you will choose name + city from dropDown,
When you select an option from name dropdown the city dropdown shoudl update to have only cities under that name.
I wrote this sql, but doesn't work. does page need to be refreshed?
have can I get this to work?
SELECT TEMP_Cities.City, TEMP_Cities.City
ON TEMP_Neighborhood.Name = TEMP_Cities.Name