Sample data · this browser only

Work tasks

Office work: a task code, assigned to an employee, optional client and project. Combos store IDs. Startup is fmnuMain.

What this demo shows · Tasks is a personal to-do — this is work against a client · Demos

Open hides Done and inactive, like qselWorkTasksOpen.

ID	Activity	Client	Status

Work task

ID	Company	Contact	Phone

ID	Project	Start	Due

Save or select a project first, then add a task.

Activity	Associate	Date

A Microsoft Access office task book in the browser: an activity code, an employee, an optional client company, and an optional project.

Not personal Tasks — that slug is tblTasks with AssignedTo as a name. This is tblWorkTask with FKs.
Associates are employees — tblEmployees matches Time Card.
Clients are companies — frozen tblCustomers, not salon tblClient.
Tasks child tab — idle until the project is saved. Combos store IDs.
Unsaved changes — Yes / No / Cancel before leaving a dirty record.

Yes. Task, client, employee, and project are separate tables with FKs. The source vacation/sick task-code catalog is omitted this pass.

Sample data only. Source: Tasks on access-diva.com.