Related Tables

[FrayKay]

I am creating an Issues database. Within this database I have a "Review
Comments" Memo field. I have created another table(MemoTable) with columns
"Memo" and "MemoDate" as I want each entry in the Review Comments column to
be Date and Time stamped. First of all is this the right thing to do and if
it is how do I join the Review comments field to the MemoTable so that all
the comments are show with their date and time.

I am new to this so go easy on me.

Thanks in advance

 

[Arvin Meyer [MVP]]

I am creating an Issues database. Within this database I have a "Review
Comments" Memo field. I have created another table(MemoTable) with columns
"Memo" and "MemoDate" as I want each entry in the Review Comments column
to
be Date and Time stamped. First of all is this the right thing to do and
if
it is how do I join the Review comments field to the MemoTable so that all
the comments are show with their date and time.

First rename any field named simply as "Memo" to either "IssueMemo" or more
simply, "Note", since the word "memo" is a keyword.

If there is to be only 1 comment, or that comment is only concerned with the
initial timestamp, the design might better look like:

tblIssues
IssueID - PK - Long Integer (autonumber)
IssueDescription - Text
... other fields describing Issue

tblNotes
NoteID - PK - Long Integer (autonumber)
IssueID - FK - Long Integer
NoteDateTime - Date/Time (timestamp)
Note - Memo
... other fields describing the note (like username)

tblIssues and tblNotes have a 1 to many relationship, joined on IssueID.