Updateable BAQ with UNION

[dhewi (Daryl Hewison)]

You need to use Advanced BPM and code it for yourself.

Fortunately that isn’t quite as big a task as it sounds, because you can cheat by using the code Epicor creates for you. If you create a standard BAQ for each table singly, you can copy the code from those into a new blank Custom Code widget in your Union BAQ with Advanced BPM Update.

Here’s another thread where similar is discussed:

Update multiple tables with advanced BPM update

Here’s a butchered bit of an Advanced BPM Update in case it helps (I’ve taken out a load of stuff that isn’t relevant except to our particular requirements). As you can see, except for having two SvcContracts in one it isn’t very different from the AutoGenerated code. You just need to sift the ttResults data for the bits you need for each update, assemble each UpdateExt tableset, and do both updates. try { Erp.Contracts.PriceLstSvcContract hPriceLst = Ice.Assemblies.ServiceRenderer.GetService<…