HI all,

I am new to VFP, so please be patient. I have 2 remote views:
1. order_view(PK:order_id, FK: city_id)
2. loation_view(PK :location_id, location_id is the automatic number)
I have used the order_view to designed a formset that includes 2 form (named Form1 & Form2).
On Form1 I have a combo box for the users could select or enter the value. I set this combo box with:
RowSourceType = 6-Fields
RowSource = location_view.location_city, location_id
On Form2 I used the Insert-SQL to insert fields to location_view.The coding as following:

Insert into location_view(lo_address
                          lo_city,;
                          lo_state,;
                          lo_zip,;
                          lo_country);
       values(Thisformset.Form2.txtAddress.value,; 
                  Thisformset.Form2.txtCity.value,;
                  Thisformset.Form2.cboState.value,;
                  Thisformset.Form2.txtZip.value,;
                  Thisformset.Form2.txtCountry.value)              
   Messagebox("The New Co-location is added into the databes",;  
                        48, "Addition Message")

When the users enter a new location_city that doen't exist in combo box, they need to add this new. They go to Form2 to add the new location then come back Form1. At this time, they drop down the combo box the location_city and location_id should be in there already. The problem is the location_id in combo at this time is 0 always. Now, the location_id (automatic number) just returns to correct value if the user exist either this form and log off the application then log in application and run form again. I want the location_id in combobox would be correct value when the users go back Form1. I hope how I explain my problem could be clear. I believe somebody here can hepl me to solve this. All suggestions, tips or ideas would be appreciated. Thanks in advance.

Daisy.