I have customer, contacts and callback tables. The customer and contacts tables are straightforward but I am not too sure how to model the callback table.

Basically a sales rep will have a list of contacts to call with the date they should be contacted, notes on the call etc. When the rep calls, he/she needs to note the actual callback date (not always the date he should have called). He notes the converstion and then needs to put a future date at which he will ring back. At the moment this is on an Access Database with the following attributes.

CallBack Table

callBackID - PK
contactID - FK ref Contact Table

I am note sure how to do the dates so that the rep can see a history of the notes and the dates.

Thanks for any comments.