Hi all,

I am designing a formset that includes 2 forms. On Form1 I have a combo box. The user can auto-select or enter the item. If the user enter a new item that doesn't exist in combo box, they should go to Form2 to add that item. On Form2, I use insert-SQL to add the fields to the remote-view(named customer_view, PK: customer_id - automatic number). When the user go back Form1 and drop down the combo they will see the added item must be in combo list already. The combo is set as following:
RowSource = customer_view.company_name, customer_id
RowSourceType = 6-Fields
My problem here is after adding the new customer and come back Form1 then check the combo list the company_name is the correct value always, but the customer_id is 0. Just if the user exit the formset and run form again the customer_id is the valid value now. I would like the customer_id in the combo box must be a correct value right the user go back Form1. I believe someone out there will have the way to solve my problem. I am still new to VFP, so I know I have much to learn. Any suggestion or tips would be appreciated. I am looking forward to hear from you. Thanks in advance.

Jenny.