Hi Marcia,

Thanks a lot for your response. Following is the code I used to add a new customer to the customer_view(this is a remote_view, PK: customer_id - automatic number):

WITH Thisformset.Form2
     Insert into customer_view(cus_company_name,;
                               cus_company_website,;
                               cus_address,; 
                               cus_city,;
                               cus_zip,;
                               cus_state);
             value (.txtCompanyName.value,;
                    .txtWebSite.value,;
                    .txtAddress.value,;
                    .txtCity.value,;
                    .txtZip.value,;
                    .cbState.value)
      Messagebox("The new customer is added into the database.",;
                 48, "Addition Message")
ENDWITH
Thisformset.Form1.cboCustomerName.Requery

I also set up the cboCustomerName with:
BoundTo = .T.
ControlSource = None
RowSource = customer_view.cus_company_name, customer_id
RowSourceType = 6-Fields
Could this be clear enough? One again, thank you very much for your help.

Jenny.