Hello, I have two tables, looks as follow.<BR><BR>TOPIC<BR>------<BR>TOPIC_ID<BR>STATUS_ID<BR>TOPIC<BR><BR><BR>THRE AD<BR>-------<BR>THREAD_ID<BR>TOPIC_ID<BR>STATUS_ID<BR>THREAD<B R>THREAD_DATE<BR>NAME<BR><BR>I want to update STATUS_ID in TOPIC when I post a new THREAD.<BR>I guess the best would be to use a trigger?<BR>Don&#039;t know much how you write them so if someone please could help or point me in right direction.<BR>My plan is to always show the updated STATUS in TOPIC while I have history in the THREAD TBL.<BR><BR>Thanks for a great site.<BR><BR>Linkan