I am requesting some help on an Access database I'm building for the Philadelphia Mural
Arts Program to track participation in one of our special projects. I'm hoping someone can help!
I have three tables with fields as follows:
Table Participants: Participants enroll in our program and we collect name, address, phone, etc and whether they are enrolled at site X, Y, or Z and for program Year 1, 2, or 3. Participants can not enroll for more than one year or more than one site.
Table DailyWorkshops: Daily workshops are set up to show the workshop date, whether it was an A or B session (two sessions per week), who staffed that day's event, what artists attended, and what activities went on.
Table ParticipantAttendance: Then I want to be able to check off what participants showed up that day. I have a form DailyWorkshops and want to have a subform/subtable that I can check off whether each participant attended All, None, or Part of that day's session. I'm having trouble creating that subform. I think this information should ultimately be STORED in the ParticipantAttendance table but I'm trying to figure out how to have an input table to check off the participants each day.
Any help would be so much appreciated.... I can share the database as I've built it so far if anyone wants to look at it and send it back to me or talk on the phone .... thank you so much!!
Level *(here I have a lookup to fill in HALF/PARTIAL/FULL, not just yes/no)*
Please Note: If you hit "REPLY", your message will be sent to everyone on this mailing list ([address removed])
This message was sent by Maneesha ([address removed]) from PhillyDB.
To learn more about Maneesha, visit his/her member profile
To unsubscribe or to update your mailing list settings, click here
Meetup, PO Box 4668 #37895 New York, New York[masked] | [address removed]