I have multiple teachers who need to enter contact information such as how many contact hours, date, what they did, etc. into the database which then spits out statistics for the month for us to keep track of how many hours they work with clients so that we could bill our funding agencies.
The original database currently has 10 identical forms, with Teacher field set to default # for each teacher.
(1 = Mr John Doe, 2 = Mrs. Jane Doe, etc)so that teachers wouldn’t have to select their name in order to link their name to the current record each time they enter a new record.
This worked OK for a while…However, now each time I make a change to one form, I have to do the same changes for other 9 forms. To compound the issue further, I’m interested in programming a code that would automatically add a new client name if not in list. This code won’t work because I’d need to create 10 identical code, each code being assigned to each teacher’s form.
I was thinking — Would it be remotely possible to code the switchboard to automatically assign teacher’s ID to single form when the teacher presses the button that has that teacher’s name?
If possible, then I need to know what the code should look like and keep in mind — A teacher could enter multiple records during a single session. All records must have teacher ID assigned to each record.
Thanks!
