Creating a field for notes

  • Thread starter Thread starter james allen
  • Start date Start date
J

james allen

How would I go about creating a field that would allow me
to enter new notes with current date whenever I open a
record and store the notes seperately by dates. I have
customers that I call. I want to take notes from the
phone call with the current date. I would then like to
search and look at the notes by date, keyword etc.
 
You would need to create a new table with DATE, NOTE, and CUSTOMER# fields.
You would need to build a relationship between this table and the Customer
table (classic one-to-many relationship here).

You could create buttons on your customer data form to "add call comments"
this could open a new pop-up form in which your notes could be entered. The
date and time could defualt.

If you use the wizard to create the customer contact data abse that comes
with Access, I think there is a sample of this. It is a button that says
"calls..." on the customer form.

Hope that helps,

Rick B
 
Back
Top