Table Setup

[gazmercer]

Hi

New to the forum and pretty new to MS Access.

Here's what I intend to do.

I want a table for Special Tasks. This will include TaskID, Date, Time, Reason, Description and Dependencies.

I want a table of staff

For each task each member of staff will have a tick box for "Needs to Read" and "Has Read".

In a form I want to be able to enter new tasks using the task table, I also want to use a subform that allows me access to the list of staff and if they have read the task or not.

There is probably an easy way round this but at the moment it's just not clicking into place.

Can someone point me in the right direction for table setup and relationships ??

 

[Kelemit]

Staff table:
Staff ID (Primary Key)
Staff Name
Staff *** (Any other fields you want)
Staff Currently Hired (Yes/No)

Task Table
Staff ID
Task ID (Not necessary as currently described) (Primary Key)
Task Name
Task Description
Task Read


Link Staff.StaffID to Task.StaffID. It will be 1 to many, enforce integrities.

Don't need 2 fields of Needs to read / has read. Just make it a yes no. IF its checked, its been read, if its not check, it needs to be read.

Then you can do queries based on that one field, if read = true will get you tasks that have been read, if read = false will get u all unread tasks.

That staff currently hired is there because you will want to (if I am guessing right) keep track of ALL tasks, even if the employee is fired. If you do the "delete record because employee is fired" mode, all tasks linked to that employee will be deleted (if enforce integrity) or pointless because the linked data will be gone.

Clicking yes / no to currently employed will allow you to removed previous employees from being viewed / drop downs / etc while still maintaining their records.