I have a Form with several fields of which some get their values from Drop Downs that get their values from another Table.
For example if I'm populating an address Table, and in my Form I have a City Drop down which gets it's list of cities from a City Table, and in the same Form I have a Text field called CityID. I need to set the default value of the CityID field based on the City the User has selected from the City DropDown.
How can I do that when using a Form Control in edit mode?