I have a list of Milestone records, each has a start date, end date and Project. The Project field is a Link to another table of Projects. Then I have a lookup that looks up all of the Tasks associated with that Project, which are being pulled from another table. The primary field in the Tasks are dates. What I want is a way to filter this lookup to only show only the tasks within the date range of the Milestone. So I can see all of the tasks associated with a specific project, during a specific milestone.
Or some way, when someone makes a task in the Task List, that it can see the date, the Project, and assign a Project Milestone value to it based on those two pieces of data.