Sean
|
Posted: 12/02/2003, 11:30 AM |
|
I have a single record form that updates a database table called "Message". Once the record form is submitted, I would also like it update another table called "Thread" with the parameter threadLastModified. The unique identifier between both tables is threadID.
This is a forum that I am trying to complete, and everything works fine, but when I update a thread with a reply, it does not move the thread to the top of the list on the main forum page. I figure if I can update the table where the main forum page gets its sorting parameter (threadLastModified), then it will work.
Any ideas or suggestions would be greatly appreciated. I can zip up my project and database if needed to look at.
I am using CCS 2.2, ASP & Access 2000
|
|
|
RonB
|
Posted: 12/03/2003, 1:54 AM |
|
Use the after insert event to update the second table.
|
|
|
Sean
|
Posted: 12/03/2003, 8:17 AM |
|
Thanks for the reply, but could you be a little more specific?
I have looked through the help files and this community, but everything I try doesn't seem to work.
Can you provide (or point me to) some code samples?
Keep in mind that the 2nd table already has a record that exists, I just want to update a specific field in the record.
Thanks.
|
|
|
|