I have a task list that assigns tasks to specific future events. The custom task has a lookup column that is based on an events calendar. Is there any way I can cleanup this lookup list to only show events that will be occuring >=[Today]? I would write a calculated column in the events calendar, but you cannot use [Today] or [Me] in a calculated column.
Perhaps I should just set the events to delete after they've occurred?