467,878 Members | 1,263 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 467,878 developers. It's quick & easy.

HELP! Multiple entries for a field or adding fields (by end user)

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
Jun 28 '07 #1
  • viewed: 1093
Share:
1 Reply
MMcCarthy
Expert Mod 8TB
Create a new table for the comments with a foreign key reference to the main table. Add a continuous subform to the main form to allow the comments to be added as records.
Jul 4 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

1 post views Thread by Roy Adams | last post: by
2 posts views Thread by Gail Zacharias | last post: by
3 posts views Thread by Bernard Lebel | last post: by
reply views Thread by jack112 | last post: by
reply views Thread by MrMoon | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.