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?
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.