What is the best way to design a task selector.... 1

[Pack10]

I am developing an app where a supervisor will be assigning tasks to staffers. What they want is some type of rolling ticker that automatically picks the next name in the list. What's the best design for something like that. (Would date/time assigned) be the way to go.

 

[dhookom]

What "list"? How would a staffer become "next"? What do you mean by automatically picks?

Have you created any tables yet?

Do you need to track when a staffer might be on PTO/holiday/vacation/sick?






































Duane
Hook'D on Access
MS Access MVP

 

[Pack10]

No tables have been created.
Items come into a mailbox. A supervisor will assign that to a staffer. By list, I mean the 6 staffers that can be assigned to. I guess it's like a stack. Next one on the stack gets the assignment. I am thinking of a table of the 6 names with a field for date/time selected. When selected store the date time in the record with the oldest date time value. Do you have a better design.

 

[MajP]

Are you building an Access application? If you have a database and a table

tblStaff
staffID
other staff fields

tblTasks
taskID
taskDescription
staffID_fk (foreign key relating a task to a staff member)
dtmAssigned (date assigned)

the next person can be determined as follows

qryNextAssign:

SELECT Top 1
tblStaff.StaffID,
tblStaff.LastName,
FROM
tblStaff LEFT JOIN tblTasks ON tblStaff.StaffID = tblTasks.staffID_fk
ORDER BY
tblTasks.dtmAssigned,
tblStaff.LastName;