Using infragistics button (not the mmUltrabutton), I tried to create new record in parent-child tables. Code is below:

    this.oPsDatacenter.NewRow();
    this.oAppsysUsers.NewRow();
    this.oAppsysUsers.Entity.userdcno = this.oPsDatacenter.Entity.dcno;
    this.oPsDatacenter.SaveDataSet();
    this.oAppsysUsers.SaveDataSet();

dcno field is an identity column using SQL 2005 database.

It gives an error below:

Dynamic SQL generation is not supported against multiple base tables.

BTW, the error is pointing to the this.oPsDatacenter.SaveDataSet() command.

I use mmUltraButtonNew and mmUltraButtonSave but it gives me the same error but this time code looks like below:

   base.OnClick(e);
   this.oAppsysUsers.NewRow(new AppsysUsersDefaultValues(this.oPsDatacenter.Entity.dcno));

I created AppsysUsersDefaultValues class:

public class AppsysUsersDefaultValues
{
    public int dcno = 0;
     
    public AppsysUsersDefaultValues(int dcNo)
    {
        this.dcno = dcNo;
    }
}

TIA