Advice Please

[Guest]

Im new to access and databases in general and would be gratefull for any
advice /help you could get me...

I need to create a database with records of about 50 individuals (various
feilds) , this I can do no problems.

What I need to do is have someway of selecting the record and then having a
free type text box where I can put an update/notes etc. on that record. This
needs to be date/time stamped and then added to the master record.

I need to be able to view the records with all the updates (some kind of
reporting) . This needs to be view only , non editable

What do you think is the easiest and most effective way of achieving this?

Thanks

Dean

 

[John Vinson]

On Mon, 27 Jun 2005 11:30:02 -0700, "Dean Cowlishaw" <Dean

Im new to access and databases in general and would be gratefull for any
advice /help you could get me...

I need to create a database with records of about 50 individuals (various
feilds) , this I can do no problems.

What I need to do is have someway of selecting the record and then having a
free type text box where I can put an update/notes etc. on that record. This
needs to be date/time stamped and then added to the master record.

If each individual may have multiple notes, you need a second Table,
let's call it Notes. This could have the following fields:

NoteID << primary key, probably an Autonumber
PersonID << link to the Primary Key of the table of individuals
<< DON'T use the person's name as the key, names are not
<< unique!
Note << Memo field
NoteDate << Date/Time field, default value Now()

You could use a Form based on the people table, with a Subform based
on Notes to do your data entry.

I need to be able to view the records with all the updates (some kind of
reporting) . This needs to be view only , non editable

Just make a copy of your data-entry form and set its Allow Updates
property to False.



John W. Vinson[MVP]