Hello- Apologies if this is a basic question, I'm an Access novice that's trying to learn the program and help out some folks by digitizing a currently manual paper/pencil/Excel process. My question is specific to form construction, but I'll include the whole background, in case there's something I could be doing better.
The goal: Friend is in charge of collecting and maintaining community service records for the students of a local private school. The community service is accrued through school sanctioned events. This information is needed for awards and National Honors Society eligibility. Current process is she has a record for each student in an Excel sheet and manually augments their hour totals as events are completed. It's a small school, so only ~300 records to worry about, but still a tedious process.
My plan: I currently have several tables set up:
- Students: This contains records on the students and should hopefully only need to be entered once.
- Clients: This contains records on the entity the community service is done for and contains background and contact info.
- Events: This contains records for each individual community service event.
One client can have one to many events, one event can have one to many students participating. Set up this way, I should be able to report a total of any individual student's total hours.
Where I'm having difficulty is assigning the students to a specific event. The form user needs to select from the list of all students in the Student table to relate them with the specific event. As of right now, adding students is using the combo box control, but that will become cumbersome once all the students are added.
What I'm hoping for is a control which is essentially a combo box, but will auto filter by a specific field (last name) in the Student table to make entry easier.
Thank you!