Diary Entry in Access Form

[jeff.white]

I am more or less famillar with creating a basic form, with a table
and some queries and reports. What I would like some help with is
creating a 'project' form where our department projects are kept and
updated. The basic stuff is there: project name, start date,
completion date, priority, describtion. What I'd like to add is a
field that will be used to enter a status. Then when saved the new
status or updated status is then added as a diary entry, which I guess
would be another field, say appended to the dairy field. It it might
look like:

Status: Met with client

Dairy:
2/2/07 schedule meeting
2/5/07 Met with client

Is there a way this can be done?

Thanks for all your help!!!

 

[Guest]

You need a separate table for the diary entries i- t will contain a foreign
key pointing to your main table primary key. Make sure you define this
relationship in 'table relationships'. You then need a subform for the diary
entries to be placed on your main form. The form and subform will be linked
vuia the key/foreign key. Look in Access Help for 'subforms'.

-Dorian

 

[jeff.white]

You need a separate table for thediaryentries i- t will contain a foreign
key pointing to your main table primary key. Make sure you define this
relationship in 'table relationships'. You then need a subform for thediary
entries to be placed on your main form. The form and subform will be linked
vuia the key/foreign key. Look inAccessHelp for 'subforms'.

-Dorian









- Show quoted text -

Thanks...I've checked out you suggested, and I think I have what I
need. So far, it seems to work, thanks for your quick repsonse!