Hi All,
I am struggle a bit here and need your guidance on how to accomplish what I described in the title:
I have 3 tables:
tbl_activities - contains a list of activities
tbl_districts - contains a list of districts
tbl_districtactivities - This is the district transaction that shows a list of activities that is needed to be completed by every district. (contains status and completion date)
I am using a district form with the subform that is from tbl_districtactivities. I can add the activities in the form manually without a problem but what I need is for all of the activities to show and not just the ones that i've added.
So eventually, my tbl_districtactivities should have the following data:
districtactivitiesID, districtID, activitiesID, status, completiondate
1, 1, 1, open, [blank]
2, 1, 2, open, [blank]
3, 1, 3, Done, 1/5/2015
That's for District 1 for example.
Then for district 2, it should continue and show the following:
1, 2, 1, Done, 1/4/2015
2, 2, 2, open, [blank]
3, 2, 3, Done, 1/5/2015
Hope my question made sense. I know that isn't the best way to do it but it has to be done that way. It's basically just like a checklist. You show all of the activities that needs to be done per district and just tick off the one that's been done.
Is there a better way of doing this? I would love to get your inputs.
Thank you,
J
I am struggle a bit here and need your guidance on how to accomplish what I described in the title:
I have 3 tables:
tbl_activities - contains a list of activities
tbl_districts - contains a list of districts
tbl_districtactivities - This is the district transaction that shows a list of activities that is needed to be completed by every district. (contains status and completion date)
I am using a district form with the subform that is from tbl_districtactivities. I can add the activities in the form manually without a problem but what I need is for all of the activities to show and not just the ones that i've added.
So eventually, my tbl_districtactivities should have the following data:
districtactivitiesID, districtID, activitiesID, status, completiondate
1, 1, 1, open, [blank]
2, 1, 2, open, [blank]
3, 1, 3, Done, 1/5/2015
That's for District 1 for example.
Then for district 2, it should continue and show the following:
1, 2, 1, Done, 1/4/2015
2, 2, 2, open, [blank]
3, 2, 3, Done, 1/5/2015
Hope my question made sense. I know that isn't the best way to do it but it has to be done that way. It's basically just like a checklist. You show all of the activities that needs to be done per district and just tick off the one that's been done.
Is there a better way of doing this? I would love to get your inputs.
Thank you,
J
