Technote Details :: Check master records issue

When trying to submit data into a table, through a form created using MX Kollection 3 modules (either Insert Record Form Wizard or NeXTensio Form), I get an error message saying "Check master record failed.(TRIGGER_MESSAGE__CHECK_MASTER_RECORD)". For NeXTensio, the message is like this: "tNG_multipleUpdate error. (MUPD_ERROR)<br />Check master record failed. (TRIGGER_MESSAGE__CHECK_MASTER_RECORD)"

• Products: All InterAKT products that use the Transaction Engine

• Operating System: All.

• Server Models: All.

• Dreamweaver version: any.

This happens because data that is submitted is being inserted into a detail form, and the Check Master record trigger, which verifies that the master record exists, has thrown an error. This means that the master record specified in the detail table's foreign key does not exist.

In order to solve this issue, you can do the following:

• Use a drop-down menu to display possible values for the foreign key. This way, the risk that an incorrect master ID is entered is reduced.

• Check the master table and verify if the desired record exists.