S
serviceman via AccessMonster.com
Hi All,
I have three tables EVENTS,STUDENTS,ATTENDANCE. The STUDENTS table stores all
of the student info, with STUDENT_ID as the (Autonumber) primary Key. The
EVENTS table stores info about different classes that go on at our school,
such as start & stop times, what day(s) this event happens, and if it is a
one-time event, the date of that event. The primary key of EVENTS is EVENT_ID
(autonumber). What I would like to do is create a form where I can look up an
event from the EVENTS table, add the date that the event occured, select many
students from the STUDENTS table, and then save all of these records in the
ATTENDANCE table. The ATTENDANCE table has 3 columns; EVENT_ID,STUDENT_ID,
EVENT_DAT.
I'm new to Access, learning by leaps and bounds. My background is SQL, so I
can handle the table and query stuff, but I can't figure this Form out to
save my life! It would be good if this form opened in a way that the user
could see a table view of all the students to select from, and then just
click to select each one, but any ideas would be greatly appreciated!!
Andy
I have three tables EVENTS,STUDENTS,ATTENDANCE. The STUDENTS table stores all
of the student info, with STUDENT_ID as the (Autonumber) primary Key. The
EVENTS table stores info about different classes that go on at our school,
such as start & stop times, what day(s) this event happens, and if it is a
one-time event, the date of that event. The primary key of EVENTS is EVENT_ID
(autonumber). What I would like to do is create a form where I can look up an
event from the EVENTS table, add the date that the event occured, select many
students from the STUDENTS table, and then save all of these records in the
ATTENDANCE table. The ATTENDANCE table has 3 columns; EVENT_ID,STUDENT_ID,
EVENT_DAT.
I'm new to Access, learning by leaps and bounds. My background is SQL, so I
can handle the table and query stuff, but I can't figure this Form out to
save my life! It would be good if this form opened in a way that the user
could see a table view of all the students to select from, and then just
click to select each one, but any ideas would be greatly appreciated!!
Andy