Locking or preventing old data from being modified in a tex field ("notes") but still being able to input new data
I working to design a medical database. using Filemaker PRO version 12. I've created a portal for medical record notes along with a time stamp and user that inputed. My difficulty is figuring out how to define a calculation or way to prevent in the "notes" field to prevent previous modification or deletion, but to be able to input new notes at a current or later date.
PS: I am new at the program if you have any suggestions on best videos/books/software would be great
Ive learned about scripts on exit, but cannot figure what steps. Also I learned about admin security features.
Report An Issue is intended for Reporting Possible Software bugs. Questions on how to work with FileMaker Pro should be posted in the FM Pro Forum Section. (See tab at top of this screen.)
I would not use a single field for recording multiple notes. Use a portal where each row of the portal records a different note.