Results 1 to 6 of 6

Thread: Form Layout

  1. #1
    Join Date
    Apr 2002
    Posts
    14

    Unanswered: Form Layout

    Bare with me on this one. I have a table that contains over 50,000 student academic achievement records. The field names are as follows:

    Student ID
    Last Name
    First Name
    Test Name (Algebra, History, etc.)
    Test Score (1, 2, 3, 4, 5, 6)
    Test Year (Winter 2001, Spring 2001, Winter 2002, Spring 2002, etc.)

    Individual students are listed as many times as there are tests. For example:

    123456 Smith Jose Algebra 1 Winter2001
    123456 Smith Jose History 3 Winter2001
    123456 Smith Jose Spanish 4 Winter2000

    My problem is this. I'm having difficulty creating a FORM that will group and display all of Jose's test scores on one screen and allow users to edit. Is this even possible?

    Currently, Jose's test score appear on as many screens as there are tests.

  2. #2
    Join Date
    May 2002
    Posts
    37
    alfman,

    Yes this is possible.

    You would make this happen with a subform.

    At the top of the form you would place your unique identifier (in combo box format) (student id).
    The subform would contain information related only to the student id specified.

    For an example of this in action e-mail me and I will send you a database using the fields you have specified.

    (It may even help if you can send me a shell of the db with one or two false records so you can see it in action.)

  3. #3
    Join Date
    May 2002
    Location
    at the corner of flotsam & jetsam, just within the walls of reality
    Posts
    21
    if i'm not mistaken, studentID is not a primary key?

  4. #4
    Join Date
    May 2002
    Posts
    37
    Originally posted by lostdreamer
    if i'm not mistaken, studentID is not a primary key?
    If necessary, you could concatenate a few fields in the qbe grid until you have a "pseudo" primary key.

  5. #5
    Join Date
    Apr 2002
    Posts
    14

    Attachment for caustin0

    attached is the sample MS Access database.

    Thanks for your help.

    alfman
    Attached Files Attached Files

  6. #6
    Join Date
    May 2002
    Posts
    37
    In response to Alfman
    (The form will open when you enter the db, Select a student and data will populate in the subforms. Each area is tab'd out for the student (data, math, science).)

    Let me know if I may be of further assistance.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •