Deleting data

This section describes how you can delete records, for example a customer or part record (including all corresponding data), from forms.

  1. Open the module and then the form from which you want to delete a line.
  2. Select the line you want to delete.
  3. Click Delete (CTRL+D) to delete the record.
  4. Click Yes to confirm the deletion. An automatic check is performed to see whether deletion of the data is permitted. For example, a customer cannot be deleted if offers or orders for this customer still exist. If deletion is allowed, the entire record will be deleted. This way, you could, for instance, delete an entire customer record including all information from the various tabs.

Note: Deletion of a record cannot be undone.

If you cannot delete data

As mentioned above, automatic checks are performed to determine whether a particular record can be deleted. If any obstacles are found during this check, a message will appear, such as the following:

Failed to delete the record(s) with key value PartCode = INS-MR from table T_PartMovementMain.

The message has a red icon containing a white cross. Double-click it to display details of the message, such as:

The DELETE statement conflicted with the REFERENCE constraint "FK_FROM_T_PartMovementOverInvt_TO_T_PartMovementMain". The conflict occurred in database "TestEngR2_46DB", table "dbo.T_PartMovementOverInvt", column 'PMMainCode'.

This message gives your application administrator and the Isah Support department important information about the reason why deletion is denied. To delete the record anyway, you need to remove the problem first by modifying the relevant data in Isah.