Quality Check Task, Updating Column Content

Click the Item table and select the Description column in the Update Columns section. This will bring up the Update Column Properties from where we can select a Value and a Value item.

After having changed the update column for Description to the Item Value, the SQL script will now look like this:

Notice that the Description column will be updated if found to be empty in existing rows, and also when it has been inserted due to a missing primary key.

The significance of the Referential check only is that Update columns will only work on new rows being inserted due to missing primary keys.

The SQL script is then reduced to this:

In the perfect world all relations should be checked in this way, and each relation pair must be defined in a similar manner in the Tables tab.