Skip to main content
Question

Limit The Number of Tasks Worked

  • November 30, 2020
  • 0 replies
  • 15 views

Forum|alt.badge.img+5
For over a month I've been trying to find a way to limit the number of tasks worked.  My application is setup with a table called Client Request Form.  One of the request types on this form is a Medical Record Request.  We have a specific provider who has asked us to limit the number of medical record requests we send to a physician's associated facility, per day.  I need a way to perhaps put this required number of tasks in queue each day.  So for example, if the end-user logged in this morning, they might see the following:

25 ABC Surgery Center
50 DEF Surgery Group
4  XYZ Surgery Center

Of the above, I need to be able to only send 3 of each, per day.  In addition, I can't exceed sending 12 requests per facility per week.  Any suggestions on how to accomplish this?

Some additional information that may be needed:
Parent Table: Client Request Form
Child Table: Record Request (Client Request Form & Record Request: one-to-many relationship)
Child Table: Physician (Record Request & Physician: one-to-many relationship)
Child Table: Facility (Physician & Facility: one-to-many relationship)

------------------------------
Danaya Bryant
Business Analyst
The van Halem Group
Atlanta GA
------------------------------
This topic has been closed for replies.