Results 1 to 4 of 4
  1. #1
    Join Date
    Nov 2004
    Posts
    78

    Unanswered: Very interesting linking question

    I have redesigned Microsoft’s “Students and Classes sample” DB to fit my needs.

    The DB has now only 3 tables, Classes, Student & Classes, and Student

    Each Class can have multiple Students
    Each Student can be assigned to multiple Classes

    (Some of my business structures)
    Every Student that brings other Students will get an award for each Student.
    (Just believe it) 2 Students can bring the same Student and both will get the award

    The Student that was brought in by the first Student, does not have to be a member of any class. However, He/She will be stored on the same Student table.

    Now, I need a report that prints the class and all It’s students
    Underneath each Student, I need a sub report (Or any other way) that shows the name of all Students brought in by the current Student.

    The question is, how can identify which Student was brought in by the first Student?
    Do I have to add more fields or tables?

    I have attached my sample DB so you can take a look of what we are talking.

    Thanks
    Joe

    Even if that’s not possible, I would appreciate any replies

    Ps.
    As you understand, that this is not my real business DB. However, with this sample it’s much easer to describe my problem.
    Attached Files Attached Files

  2. #2
    Join Date
    Apr 2004
    Posts
    41
    I assume that by "first Student" you mean the first (of at most? two) student that brought in a particular student. Clearly in order to retrieve that information it must be input and I don't see where you do that. How about adding to the student table two fields - one for the ID of the first student and another for the ID of the second? And I'm curious as to why it matters who is the "first Student" if both receive the award.

  3. #3
    Join Date
    Jan 2004
    Posts
    115
    Hi Everyone
    Last edited by Tommiller; 11-14-04 at 00:24.

  4. #4
    Join Date
    Nov 2004
    Posts
    78
    Hi,
    You are right.
    I made a typing error

    My original Quote
    """The question is, how can identify which Student was brought in by the first Student?"""

    Should be changed to
    """The question is, how can identify which Student was brought in by the CURRENT Student?"""

    I’m sorry for the confusion.

    Thanks again
    Joe

Posting Permissions

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