Always change field

This topic is locked

Always change field	3/27/2006 5:36:29 PM
PHPRunner General questions
T TVining author <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=2687&image=1&table=forumtopics' class='bbc_emoticon' alt=':blink:' /> I see that you can insert a record into a table when a record is changed. i.e. when record 175 is changed, insert a record in table CHANGED with that record number. I have a field on my main table that is called 'CHANGED' and it's a SET 'YES','NO' field. Can I somehow tell the system that when a change is made to automagically trigger the field 'CHANGED' to YES? TV <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=question&id=2687&image=2&table=forumtopics' class='bbc_emoticon' alt=':ph34r:' />


	Sergey Kornilov admin 3/28/2006
	Tony, sure, you can. Just put this line into Before record updated event on Events tab: $values["CHANGED"]="'YES'";