InfoPath Dev

Thank you so much Hilary!  Your suggestion worked.  I created a rule on the Product field if it's not blank then set the value on the Price field.   Thanks again!!!

Yes I am using a default value on my Main Source Hilary.  I have to set a default value for it to filter the price from a SharePoint list according to what Product is selected.

ErnestoM,  I thought that would solve my problem but it didn't work.  I applied the rule to when the form is open but the price still gets updated.  Can you tell me where I am going wrong?

I've created a form for staff to order office supplies.  This form is submitted to the SharePoint forms library so a SharePoint workflow can be kick off.  I have a repeating table in the InfoPath form that allows staff to order more than one items at a time.  The Product field and Price field in this repeating table are ...