adding new fields with linked vaules

M

mara

I am working with an access 2003 database that contains comments that are
updated on a regular basis in a form method. I am looking for a way to add a
new field to the record once a new comment is added that will be linked to
the project ID number and also include a time stamp. In other words,
everytime someone makes a new comment, another row should appear in the
table. This row would contain to project ID number, the comment, and the date
the comment was made. What is the best way to go about this? I'm a new user
and not extremely well versed in code writing. =[
Thanks!
 
W

Wayne-I-M

Hi Mara

It quite answer would be to create a new table (tblComments) which would be
linked to your main table. In tble Comment you could put fields such as
CommentID, CommentDate, CommentAuthor, Comment (the actual comment itself),
CommentReaction (incase another user wished to comment on the comment - hope
that makes sense). etc, etc.

If you create a subform (or popup with continous format) from tblComments
this would do exactly what you need.
 
Top