dbryant4891
5 years agoQrew Trainee
Limit The Number of Tasks Worked
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
------------------------------
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
------------------------------