Predefined table of tasks against a case?

[superblades]

Hi there,

Wondering if someone could give me some advice...

I'm creating a fairly basic case management system in Access 2007 and i'm wanting a way of populating a set of tasks when a case is created...

e.g.

I have a case table, which contains basic information about the case, case manager, ID, date created etc.

I've also got a task table with a list of tasks

When i create a new case I want it to pull in the list of tasks from the task table, the tasks are static so i wouldnt want them to update the task table but update progress on the tasks against the case.

Do i need another table for like casetasks where it populates the blank tasks and then they're updated with an ID linked back to the Case.

Does this make sense?

Any help would be much appreciated.

Many thanks

Superblades

 

[Uncle Gizmo]

I did a set of videos showing how to do something quite similar; this was to add a checklist to your database you can find out more about it on my website here:-

https://sites.google.com/site/msaccess457966vmfjg/advanced-techniques/check-lists

 

[jdraw]

Good site Tony!

 

[Uncle Gizmo]

Thank You!