Results 1 to 2 of 2

Thread: Data input

  1. #1
    Join Date
    Oct 2005
    Posts
    2

    Unanswered: Data input

    Hi

    I am new to databases and have just managed to set up my first customer database. I would know like to include a section that will enable me to log customer calls. I would like to store information such as date when to respond by and a memo section to record all that is said. This should be simiallar to a system used by a bank ie I can recall when a person last called and what they wanted. Is there an easy way to do this in my access 97 database?

    Thanks for any help.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Shouldn't be too tough. You'd want a "Customer" table to hold the basic data about each customer, including a customer ID. You'd have a "Calls" table, with a field for that customer ID, probably a date/time field to track when the call was received, and a text or memo field to hold your notes on that call. A form/subform could display a customer in the main form with their calls in the subform.

    There's probably more, but that's off the top of my head.
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •