RELATIONSHIP FOR COMMENT TABLE

[BillA]

Thus far, I have a number of tables to track a Projects/Studies with a tables
for Investigators, Studies and a joining table ensuring a M:M relationship.
I am having difficulty with what I believe should be a simple 1:M table for a
comment table. The Comment table should link to a specific study and have a
minimum or zero and likely have numerous comments. Each comment will be have
Comment Date, Type and a drop down list for Commenting person. I’m trying to
create the easiest and most flexible Table and relationship to the
Study/Project table. Any suggestions?

 

[mscertified]

Just have a comment table like you described. I dont see any need for a
drop-down for commenting person. Can't you just capture the userid of the
logged-on person? You might want a separate table to define the 'comment
types' whatever they are.
The comment will need to be a memo column unless you want to restrict
comments to the 255 characters allowed in a text column.

Dorian

 

[KARL DEWEY]

In case you do not want/can't capture the userid of the logged-on person then
in your data entry form (you are using a form for data entry are you not?)
use a listbox or combobox. The same goes for the 'comment types.'