Memo Field for Notes?

KristenD

Registered User.
Local time
Today, 16:14
Joined
Apr 2, 2012
Messages
394
I need to be able to make notes on employees for my database. For example if they are out on WC or they need a certain test, etc. The main table in my database is the tblEmployee and that is where I added the memo field called Notes.

My question is how exactly does this field work? I have been reading about it all afternoon but still do not have a clear picture of what it does. I know what I would like it to do like track changes. Like I can go into the entry from and bring up that employee and do what I need to do in the form and then sometimes it may be necessary to make a note in stating Joe Schmoe is out on WC no change of status on this date then come back in a month and say no change of status returned to previous position on this date and be able to track information through there?
 
Not the best idea based on your thread, I would add another table using employee ID and text field for your notes and possibly date fields to identify when the notes were added, then relate the 2 so you can add new notes and also track the information from a query.
 
That makes sense...Thank you!!
 

Users who are viewing this thread

Back
Top Bottom