>Hi Everyone!
>
>I am developing in VFP 3.0 and I am tearing me hair out over this one. I have a dropdown combo on my form where ControlSource = Client.City, RowSourceType = Alias and RowSource = CityStateZipTable. What I want to do is maintain a lookup table of Cities, states, and zips that the user can update on the fly when entering client information. I have code in the interactivechange method of the combo box to update the city, state, and zipcode fields if it finds a match in the CityStaeZipTable. Everything works fine except that I can't enter a new city. Am I trying to do something that can't be done here? Any suggestions?
>
>TIA.
>
>MArcia
IF you want to add information to a table that is entered into the combo box by a user you have to update the table using the 'displayvalue' of that control if what the user types in is not in the list. Perhaps something like:
Insert into CityStateZipTable (cityfield) values (thisform.comboname.displayvalue)
HTH