I am buidling a 10 day planner. I'll try to explain as simple as possible.
I have a Planning table (with field'sm PlanName, StartDate and Issues) This Planning table would tie to an Issues table (id, IssueName, IssueDescription, Status).
Here's where I get lost. When I create a new Plan (or another record in the Planning table), I want it to copy any Issues that do not have a Status of Complete to the new Planning record.
This way I can keep issues active but still go back and see what was on previous Plans.