How can I delete data in a field if another field is updated

Try this:
>I have over 8000 old images in "thumb_med" column of a table

>I created a new "new_pic" column in the table.

>I would like to delete the data in the "thumb_med" when the "new_pic" is added.
Before add event:
// Make the thumb_med field empty when adding new_pic:

then on the view page, choose which field to display image:

Note: in events, you use $values["your_field"] to write new value to the field in the db;

in view page, you use $value, which is the current field you want to display.
ACP

then on the view page, choose which field to display image:

Note: in events, you use $values["your_field"] to write new value to the field in the db;

in view page, you use $value, which is the current field you want to display.
ACP

Thanks for the quick response.

My concern ( if there should be one )

Before the add event:

If the "new_pic" is not added ( not required )

wouldn't that still empty the "thumb_med" ?
I don't want the "thumb_med" to be removed unless the "new_pic" is updated.
again with "novice" issues <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=89771&image=1&table=forumreplies' class='bbc_emoticon' alt=':)' />

> I don't want the "thumb_med" to be removed unless the "new_pic" is updated.
Yes, valid concern.
Before add events, check if the new_pic is added.

We do this by checking if the new_pic field has any NEW data by checking its length:
If (strlen($values["new_pic"]) > 0 )

{

// Make the thumb_med field empty when adding new_pic:

$values["thumb_med] = "";

}
ACP

WORKS AS DESCRIBED!!!!! Thank You!!!

Glad you find the rope. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=89774&image=1&table=forumreplies' class='bbc_emoticon' alt=':D' />
ACP