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?
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?