Trying to create an updatable BAQ for Inspection Results (InspResults) and a sub-table, but getting a “duplicate entry of an existing record” when i try to update an existing record. I tried a support ticket, but his response was he didn’t see anything obvious in my query so i should trace the business logic call…
Has anyone got an updatable one that works they are willing to share?
Have you done traces of updating existing inspection results using the Kinetic Trace helper? That way you know what the system is doing to have your uBAQ mimic the same BO calls.
Sounds like your uBAQ is trying to to a rowmod “A” instead of “U”
I am using the out of the box update – i just picked what column i want to update and select the service. I even have “Allow Add New” unchecked - otherwise there is no option to choose rowmod values.
OOTB usually doesn’t like to update multiple tables.
