Hi Linda,

Your welcome, glad you got it figured out.
Tim

>
>I had already used the RegisterPrimaryBizObj() method. I set the binding source property of the save button to the table I want to update but I still got the error "Dynamic SQL generation is not supported against multiple base tables." I went back to study my business object code and realized that the likely culprit was the query. I used a join to another table to get this information but didn't include any fields from the other tables. I re-wrote the code to use a subquery and everything works like a charm now.
>Thanks for lighting my path.
>
>
>>Hi Linda,
>>
>>>I have a business form that allows the user to add or edit records that needs to display some fields from other tables that are not maintained on this form. I had thought that I could just use the other business objects for the foreign tables to display that information but that causes the save button not to work since there are multiple tables on the form.
>>>
>>>What is the best way to handle this? Should I just stuff the values into the text properties of the various fields from the refresh method? That seems a bit cumbersome.
>>
>>I would do two things. First register your primary business object with the form using:
>>this.RegisterPrimaryBizObj() rather than RegisterBizObj().
>>Also, you can click on your save button and set the BindingSource property to the business object you want it to save records in.
>>
>>Hope that helps
>>Tim