Multiple Notes - Single Record.

[Homegrownandy]

So I have a list of jobs and each job is subject to change from the original plan.



Each change needs to be documented and dated. So what I want is a form where the site can be selected and a note written. When this is saved, a record of the current time would also be needed.

The form aspect of this seems fairly straight forward to me. I just cant visualise where the 'notes' will be stored.

Could anyone shine a light on this for me?

andy,

[CJ_London]

store notes in a separate related table which would have the notes field, a timestame field (i.e. a datetime field with default of now()) and a family key to link back to your main record. you may also have additional fields for who entered the note, next actions, etc

Alternatively if you just want the date then the following link may be of help (I presume it still works in 2013) - you need to use a memo (longtext) field type in your 'main table' and change the append only property to Yes

https://support.office.com/en-au/art...7-c2bb6283535a

but this is really just for compatibility with sharepoint so I don't really recommend it unless you are using sharepoint

[Homegrownandy]

Thank you ajax. Pretty obvious really. When I'm working on the same thing for hours I lose the ability to think sometimes haha.