attach a file

[Bob76]

I have a table of employees with data such as EmplName, Status, Jobsite,
DateHired, PayRate. I would like to link each employee to a form where the
Project Manager can write down day to day comments on each employee. I would
appreciate any suggestions on how to set this up.
Thanks a lot,
Bob76

 

[John W. Vinson]

I have a table of employees with data such as EmplName, Status, Jobsite,
DateHired, PayRate. I would like to link each employee to a form where the
Project Manager can write down day to day comments on each employee. I would
appreciate any suggestions on how to set this up.
Thanks a lot,
Bob76

You really should have a unique EmployeeID field: names are NOT unique. I once
worked with Dr. Lawrence David Wise, Ph.D. and his colleague, Dr. Lawrence
David Wise, Ph.D.

Given that... I'd suggest a table with (perhaps) four fields - EmployeeID (a
link to the employee table); CommenterID (another link to the employee table,
to select the person making the comment); CommentDateTime, a Date/Time field
with a default value of =Now() to automatically timestamp the comment; and a
Memo field Comment. You could display this table in a Subform on the employee
form, with EmployeeID as the master/child link field and a combo box to select
the ID of the person making the comment.

 

[Bob76]

Sorry, I do have Empl. No. as my primary key, forgot to put that down in my
post.

Thanks for your suggestions.. I will try out your idea and also that of
Pieter. I will have to read more about subforms as I'm not familiar with
this yet.. I'm fairly new to Access.