"Related Tasks" subform (1 Viewer)

[cnstarz]

In my database we keep track of tasks that my work center issues out to other work centers. Each task has it's own Task Number that is composed of the current Julian calendar day and the task number for that day. For instance, today there are twenty tasks, so they are labeled "016-001" through "016-020". Yesterday there were 9 tasks labeled "015-001" through "015-009". You get the point.

Some tasks are related to other tasks. For instance, we could task Person A to Remote Desktop into a server to do some server maintenance (task# 016-001). However, they may not have access to that server (either due to Firewall rules or permissions or whatever), so we would have to task Person B to ensure that Person A has access to the server (task# 016-004). Therefore, tasks 016-001 and 016-004 are related to each other.

What I would like on my Task Details form is a little "Related Tasks" subform (datasheet view) where someone could specify a related task (or multiple related tasks) by typing or choosing the related task's Task Number from a combo box. For instance, if I'm looking at task 016-001's record in the Task Details form, I would click into the combobox in the "Related Tasks" subform and click choose "016-004". Then, if I go to 016-004's record, then it'll automatically show 016-001 in the "Related Tasks" subform since I already added 016-004 as a related task to 016-001.

Does this make sense? I hope you can help as it would make things much easier when understanding the context of certain tasks. Thanks!

 

[spikepl]

So your question is ???

 

[cnstarz]

lol whoops! How would I get the Related Tasks subform working? My concept is this:

1) I view a task's (task# 016-001) record using the Task Detail form.
2) On the Task Detail form is the Related Tasks subform (in datasheet view with only one column displayed) that shows a list of related tasks. You click on the "new record" row in the Related Tasks subform and type/select a related task (task# 016-004) from the combobox.
3) Afterwards, when I go to task 016-004's record in the Task Detail form, I would see task 016-001 already in the Related Tasks subform.
4) With 016-004's record still open in the Task Detail form, I could still add another related task (lets say task# 014-005) that's unrelated to task 016-001.
5) Afterwards, when I go to task 014-005's record in the Task Detail form, I would see task 016-004 already in the Related Tasks subform.

I hope this makes sense. I don't know how to implement the subform to show related tasks.