Workflow question - best way of handling reminders and escalations

A

acs68

Hi all,

I am setting up an access app that takes customer complaints etc and need
some guidance.

There is a date field in the main table (tblComplaints) called
ComplaintDate. I also have a field called ComplaintCategory and a field
called ComplaintOfficer..

I also have a table called tblParamsComplaintCategories, that has 2 fields
ComplaintCategory and ReminderDays. ReminderDays is a number field that I
input the no of days before a reminder is generated.

So what I am trying to do is somehow schedule an email to go to the
ComplaintOfficer when the number of days since the original complaint exceed
the ReminderDays in the tblParamsComplaintCategories.

does anyone have some suggestions in how I could go about this ?

cheers,

Adam
 
Top