Not sure of the best way to do this, but here is what I am shooting for.
Basically, I am creating a DB for Project Management. I want the co workers to be able to make comments, and update those comments on an on going basis (and projects change).
So when a project in entered for the first time, we can make any notes on that project. But if something changes (like after a meeting) updates (comments specifically) can be made. I want to always keep the comments and only add to it..not edit existing (like a paper trial). the idea is that if a co worker is out, or you manager wants a project status, the can get the information from Access.
Also, I'm trying to do this from a Data Access Page. This will be published on an IIS Server.
thank in advanced for you help.
KJ