Diary Entry in Access Form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

jeff.white@amcore.com - 16 Mar 2007 14:43 GMT

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!!!

Reply to this Message

mscertified - 16 Mar 2007 15:18 GMT

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

> 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
[quoted text clipped - 15 lines]
>
> Thanks for all your help!!!

Reply to this Message

jeff.white@amcore.com - 16 Mar 2007 16:29 GMT

> 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
[quoted text clipped - 26 lines]
>
> - 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!

Reply to this Message