Archiving Notes

[Guest]

I am modifying an existing employee database which has a Notes field (text
box). I want to add a second notes field called ArchivedNotes to the form
(as a list box). I will place a button next the the first notes field
(current notes) so that when the info there is no longer needed, the click of
button appends the information to the ArchivedNotes.
I have created seperate table with relationship (1-many based on employee
ID) from the employee table to this archived notes table.
I need help in completing this theory clicking the button, erasing the
contents of the Notes field in the employee record - moving that data to a
new record in the associated archivednotes table (adding a date/time stamp).

 

[Guest]

Why use another table? Add Archive Yes/No and ArchiveDate fields. Then just
flag when it is archived and update the ArchiveDate field.

 

[Guest]

Karl, thanks for responding. However, I don't fully understand your
response, particularly the Yes/No option. But to revise on what I do gather
from your response, I could use the same table, create an archiveNotes field,
can append the current date as header when button is clicked to move the
notes being archived into this new archiveNotes (memo type) field.
If this sounds good, theory, I'm still not proficient enough w/ Access yet
to invoke the actions. Can you lend that help?

 

[Guest]

Not quite what I meant. I misread your orginal post thinking you had 1-many
employee-notes tables.

Have Notes table with the following fields --
NoteID - autonumber - primary key
EmployeeID - foreign key
NoteDate - DateTime
Note - memo

Have an Event or macro that is triggered when you double-click the NoteDate
field to append a new record and set the current date into the NoteDate field
of the new record.

Use a form (employee)/subform (notes in descinding date order) to display
the information.

 

[Guest]

Thanks. That's exactly what i wanted to do.

Not quite what I meant. I misread your orginal post thinking you had 1-many
employee-notes tables.

Have Notes table with the following fields --
NoteID - autonumber - primary key
EmployeeID - foreign key
NoteDate - DateTime
Note - memo

Have an Event or macro that is triggered when you double-click the NoteDate
field to append a new record and set the current date into the NoteDate field
of the new record.

Use a form (employee)/subform (notes in descinding date order) to display
the information.