Hi!
I have what seems to be a basic desire but yet cannot seem to accomplish this. I like the essential idea/template for this sample database. What I want to change, is the option where a comment is added to the history by the RecordSource option. I do not like this option since it cannot be edited and it also creates the Version History tag preceeding the comment. I would like to have a separate table that is called comments instead of what is implemented. I tried using an append query and was unsuccessful. I am not sure if I linked my table relationship correctly? I am assumming it should be one-to-many for every issue should have X amount of comments. I want to incorporate other fields in the comments table that will record the user, time and also allow the deleting/modification (only by the owner of the comment). Can someone suggest how I should have my table relationships setup and if i need to have a query or what the best method should be if the query is not the best choice? I have tried several different methods and am starting to destroy the original template file due to my lack of knowledge. Any help (preferably some step-by-step with explanation so I can understand, would be extremely helpful). thank you!