how can I show call history of a person on the record

A

aj20

Hi, how can I show the call history of a person on a form. I want to enter
more than one 'call date', 'call time', 'subject of the call' and 'who made
the call'. If I go to the 'calls' page/tab I should be able to see the call
history of that person and be able to do data entry. thanks
 
D

Douglas J. Steele

You need a separate table to hold this information, one row per call, with
the row having a foreign key that points back to the Person table, similar
to how an invoice has a table to hold the invoice header information and
another to hold the invoice details.

You could then have a subform that shows all of the entries in the Call
History table.
 
A

aj20

Hi, I managed to copy it from another DB and it works well, but a little
complex to understand. thanks
 
Top