RE: Using a subform to display and add info into table

Here is the info on all my tables:

Students: StudentID (PK), FirstName, LastName
Classes: ClassID (PK), ClassName
Sessions: SessionID (PK), ClassID (FK), Day, Time
Enrollments: ClassID (FK), StudentID (FK)

The form I'm talking about is named Assign, and it assigns a student to
classes. The form is based off of the Students table, then the subform I
have based on the Classes, Enrollments and Sessions tables. I'm not sure if
that is right.

Thanks for your help.

ivalum21

"Sprinks" wrote:

> Hi, ivalum.
>
> You must have a non-updateable query. If you open the query, you will
> likely not be able to change data in it, either.
>
> Does ClassID define a session? What are the primary keys of Classes and
> Sessions? If there are multiple sessions of a given ClassID you will need a
> different primary key for Sessions. A multiple field one of ClassID, Day,
> and Time would work, but it's easier to just use an AutoNumber one. You'll
> never see it anyway.
>
> Post back and I'll be able to help you.
>
> Sprinks
>
> "ivalum21" wrote:
>
> > I have a form based on a table called Students, it just displays their first
> > name.
> >
> > I have a subform where I want to display the classes the student is signed
> > up for. I have the following tables: Classes, Enrollments (StudentID,
> > ClassID), and Sessions (ClassID, Day, Time). I'm using all three of these
> > tables for my subform's record source and when I run my form it won't let me
> > input any data for a student.
> >
> > I also want in my subform to have the ClassName be a combo box that displays
> > all classes from the Classes table.
> >
> > Please help!
.

Relevant Pages

  • Form updating table instead of just pulling information from it...
    ... I have a database with Classes, Students, Enrollments, etc. tables. ... I want it to populate the sessions combobox ... it's inserting a new record. ...
    (microsoft.public.access.forms)
  • RE: Automatically Updating Table with an Append Query
    ... My database contains 3 basic tables: students, programs, and attendance. ... includes selecting students for the program and setting up sessions for a ... I created an append query to add new students to the attendance table (so ...
    (microsoft.public.access.gettingstarted)
  • The "E" Symposium W-Guard Clinic-Dec.3rd.,05 -Cesario/Zuccala
    ... 3rd.,2005 @ Roselle Park,HS., Roselle Park, NJ. ... Event day registration begins at 12:00 noon, sessions begin at 1:00pm ... Classes for the students. ... designers and instructors is $10.00 ...
    (rec.arts.marching.drumcorps)
  • RE: Automatically Updating Table with an Append Query
    ... what if I ran the sessions form from the ... My database contains 3 basic tables: students, programs, and attendance. ... I created an append query to add new students to the attendance table (so ...
    (microsoft.public.access.gettingstarted)
  • Re: two tables in a report
    ... This would be its primary key of course. ... column in a referencing table as that for the primary key column ... Sessions would contain unique pairs of values of the date and class title ... Attendance models the many-to-many relationship between Students and ...
    (microsoft.public.access.gettingstarted)
Loading