This group has helped me capture some errors by checking if a field is null
or if a time period is already booked. I have one more check to do but I
can't figure it out and I do not believe the function will be the same as
the previous checks.
I have a main form to schedule events (sports games)
I have a continuous sub form that I use to select TEAMS that will
participate in that event. A One to many relationship. (one event to many
teams)
Each team name selected in the sub form is also tied to a specific grade
level in the t_Teams. (table with team names) The grade level also shows in
the combo box but the bound column is just an ID number.
Is there a way to check to make sure I am always scheduling 5th graders to
play 5th graders and 10th graders to play 10th graders.
I am thinking I will have to search the t_Eventparticipants for team names
associated with the EventParticipantID that is currently on the form and
then check the t_Names to see if they have the same grade level associated
with the team. (GraID in t_Teams)
I really have no idea how to structure this or what function to use.
Or I could just the previous record but I am not sure how to back up a
record.
Thanks for your help.
Bill Singer
MN
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar