Apologies, I must be feeling intellectually low!
I want to create an Audit trail table. User enters a question into master Discussion Table (that bit works). I want to copy that question with username and date stamp to another table, Audit Trail, where there will be one record per thread containing all questions and answers.
First time a question is posed I have no Audit Trail record. Generically, how would I create that record? Is it an Append-type operation?
Next time the Audit Trail record exists and so what is my syntax to retrieve the Audit field and update it, appending the latest question to the top of the audit field?
Thanks!