I want to create subscription/alerting system on list items by enabling user to choose which item(s) he/she wants to track.
Couple of things to mention, there are three main columns:
Project and Milestone are lookup columns (cascade drop down) and Task is single line of text.
If user chooses to track (gets alert on item change or whatever) Milestone, than all Tasks that are children of a chosen Milestone should be included in tracking, with possibility of user to uncheck tasks by his will. Same goes for Project, if he chooses to track Project, than all Milestones (and with them Tasks) of that project should be checked for subscription.
Any suggestion how can I do this?