New key value

Change the ERP_PDM_NUMBER if desired.

Update dataset

Click on the value to be changed, change it accordingly and press the Update record [Update dataset] button.

Delete link

Deletes the data of the LINKTABLE.

Afterward follows an inquiry whether or nor the data of the ERPTABLE should be kept. Confirm/deny the inquiry accordingly.

Execute SQL-command

Opens the window of the same name.

In the SQL command entry field you can enter any command.

Example:

SELECT * FROM ERPTABLE WHERE MAT_NAME='8.8

Define the maximum number of rows in the result.

Then click Execute.

Note Using Browse ... you can display the table names and a selection of SQL commands.

Execute SQL-command

Close