Apologies in advance for the newbie question, or if you think my method is cack-handed.
I'm developing my own 'To-do list' application in Access 2010. I have a table for Tasks (tblTasks) and a table for Actions (tblActions). One Task may have one or more Actions associated with it. Action records have a 'Planned Start date' and a 'Planned End date' field.
I also have a table for Days (tblDays), holding dates from now until......well, a long way in the future.
What I'd like to be able to do is have a Single Form for each and every day held in tblDays, with a subform of Actions and the Tasks they're associated with. So that I can, for example, open up the form on Sun 24th March 13 and immediately see within the subform what Actions need to be done that day. The question is, can I link.....or how can I link.....the form and subform ?
Anyone out there who can give me some guidance on this, please ? Thanks very much.
Best wishes
Alan
I'm developing my own 'To-do list' application in Access 2010. I have a table for Tasks (tblTasks) and a table for Actions (tblActions). One Task may have one or more Actions associated with it. Action records have a 'Planned Start date' and a 'Planned End date' field.
I also have a table for Days (tblDays), holding dates from now until......well, a long way in the future.
What I'd like to be able to do is have a Single Form for each and every day held in tblDays, with a subform of Actions and the Tasks they're associated with. So that I can, for example, open up the form on Sun 24th March 13 and immediately see within the subform what Actions need to be done that day. The question is, can I link.....or how can I link.....the form and subform ?
Anyone out there who can give me some guidance on this, please ? Thanks very much.
Best wishes
Alan
