How to best keep track of multiple notes/comments in a record

[Modify_inc]

I'm using Access 2013, with a standard database (non web).

I am trying to figured out a method to keep track of notes and comments that are entered into a record. I would like them to be time stamped, and the most recent listed first.

Do I have to use a split form or similar to do that? Is there a intermediate to easy method of accomplishing this task?

If anyone has seen the Contacts Web database template in Access 2010, the 'Add a Comment' section would be ideal to what I'm looking for. Unfortunately, I'm not sure how to implement it into my database.

Thanks


Mike

[Xipooo]

I make up a notes table with a foreign key that relates back to the ID of the main table. In your notes table store the user, timestamp, and note with maybe a topic.

[Modify_inc]

I make up a notes table with a foreign key that relates back to the ID of the main table. In your notes table store the user, timestamp, and note with maybe a topic.

Thanks, I may give that a try.

I've been searching the net, and I found the 'Append Only' value you can set to a field and it will keep the history.

I'm not sure if it still works for Access 2013, because it mentions, you must set the field to memo, and 2013 doesn't use memo fields anymore, but rather Large Text.

The command to enter for the text box that will display the history is:

=ColumnHistory([RecordSource],"Comments","[ID]=" & Nz([ID],0))

but I can't get it to work.

Anyone have any luck using this in Access 2013?

[Xipooo]

Well think of the notes as a separate entity altogether. They are kept in their own table and in that table is a time/date field with a default value of Now(). That way when a record is created a "timestamp" is entered in that field. In the notes table I have an ID, EmployeeID, TimeStamp, JobID (this field relates to whatever Job/Customer/Ticket the note is for), a CategoryID (from another table which holds different general categories that the note might be about), and finally just a text field that holds the maximum number of characters.

I then build a form around that table and subsequent linked tables.