This project is based on a call center making calls to a group of customers every day.
The list of customers to call is replaced daily based on yesterdays business.
I need to be able to track how made the calls along with results and notes.
Looking for the best way to have these details saved in a separate table in order to keep a historical record of this.
I have tried an append query as well as an update query, however it isn't updating the table.
I am asking for some direction here.
* Is the append query the right approach or is there a better way?
* Do I need to do something to select the current record to update the other table?