Can I automate adding date/initials to memo

[Angel69]

We have a memo field that folks may add to on different days. Additionally, different users may add notes if the person who started to work on the transaction is out of the office. My manager would like to add a way to include the date and initials of the person that added a new memo automatically after they add a memo. Currently, we don't track user login so I'm assuming we would have to in order to get their initials. Any ideas? TIA

 

[pr2-eugin]

What you need is a New table, tbl_MemoNotes. So when a user is entering a new note it will go in as a new record in this table, and when someone wants to add; it will be a new records in the same table. So each record in the Main table will have zero or more notes in the tbl_MemoNotes. This is the right way to go with this.

 

[Angel69]

Thanks Paul but how do I show all notes in one memo field?

 

[jdraw]

Why would all notes go into 1 memo field?
If there are different Notes for each Person*Day, and the Note could be greater than 255 chars - then 1 Note per memo record.