10 week multi-task planning

[jerem]

Hi,



I want to create a planning tool that has 36 tasks. Each task displays 10 weeks with a list of names (listbox with checkbox). I want the user to be able to click in these check boxes to select who is performing what task in what week (see the print screen). So, in order to keep a history, I created 4 tables: Tasks, Employee, Plan, Week and WeekTask. Each time a new plan record is generated (new ID in tbl_Plan), 10 week records are being generated (new ID in tbl_Week) and 136 WeekTask records are being generated (new ID in tbl_WeekTask). There is a one to many relationship from tbl_Plan to tbl_Week and one to many relationship from tbl_Week to tbl_WeekTask.
Now I want the following form to update the WeekTask records with employee names based on check boxes. The problem is that my 10 listboxes all refer to the same record in tbl_WeekTask. How to I get the control source of my list boxes to update the correct record?
The print screen shows onoe task only.

[orange]

Have you considered something like M$oft Project? Is there some reason you want to build a project management tool?

[burrina]

Whats up with the 10 weeks? Why 10? There are a number of Calendar databases that you could no doubt adapt to your requirements and be much easier I would think, just my 2 cents!

[ellisthomas86]

Isn't it possible to go for an automated tool which can have every point of access and management.

[jerem]

This thread is pretty old. The application was entirely created in Access. We used a model similar to the Schedule Grid posted by Cyber Cow. Here is the link: http://www.utteraccess.com/forum/Sch...-t1333094.html