Project Update memo fields

  • Thread starter Thread starter Kevin Smith
  • Start date Start date
K

Kevin Smith

Dear all,

I am having a mental block, all I want to do is have a "progress
update" text box on a form.

The form displays information on a Project, Name; Date started;
Contact details etc. Its a really simple form. I want a text box on it
to display the latest notes entered on the project, the ability to
enter a newer update and have that displayed, and a button to display
all updates for viewing on screen or printing.

My mental block may have something to do with the fact that it is 6:30
am but if anyone can point me in the right direction I would be most
grateful.

Kind regards

Kevin Smith
 
Kevin

From the subject of your email, the implication is that you are using a memo
field. You would have much greater control if you created a new table that
holds the project id, UpdateDate/Time, and ProgressUpdate. This way, you
could use a query to get all of a project's updates, and sort them in any
order, and enter a new one.
 
Jeff said:
Kevin

From the subject of your email, the implication is that you are using
a memo field. You would have much greater control if you created a
new table that holds the project id, UpdateDate/Time, and
ProgressUpdate. This way, you could use a query to get all of a
project's updates, and sort them in any order, and enter a new one.
Click to expand...

I agree. It appears to be a series of comments now being put in a
single memo field and then you want to be able to work with those comments
individually.

A new comment table linked to the original table would then make each
comment its own record/event. Since the original writer wants to work with
them as individual events, they should be individual records.
 
Back
Top