12.5. Contact History

This functionality would also be best implemented as a subform on a customer information form. The fields on the form would be driven by end user needs, although you probably want to put in the phone number that is called (you would probably get extra points by having a drop-down box that links to the phone numbers for the client), a notes field, a field to hold the name of the person who was called, a field to hold the name of the person making the call, and a field for the date and time of the call. This allows you to create a report showing all calls made to a customer, all calls made on a particular day, or all calls made by a particular employee.

Once you make a few subforms, you see how many uses you have for them. The thing that makes them very nice is that by having the child and master fields, Access automatically put in the ID that links the records. This makes it less likely that you will end up with orphan records (phone records without a customer record, for example).