Results 1 to 3 of 3
  1. #1
    Join Date
    Jan 2007
    Posts
    2

    Unanswered: Help with Database.

    I am designing a schoolinformation database. I created my tables but when creating Entity relationship diagram. I'm having a lot of problems. When runnig queries. I have duplicate data. Here are my table fields. If there is anything that needs to be added or changed please show me. (* represents primary key and ** foriegn key)

    Student table
    *StudentID
    Lname
    Fname
    Gender
    DOB
    School

    Parent table
    **StudentID
    Parentname
    Occupation
    Phone#

    Teacher table
    *TeacherID
    Status
    Fname
    Lname
    DOB
    Address
    Phone
    Children

    Subjects
    *SubjectID
    Subject name

    Teacher_subject
    **SubjectID
    **TeacherID

    Student_subject
    **StudentID
    **SubjectID

    Marks
    **StudentID
    Grade
    **TeacherID
    TeacherComment

    I have linked all the tables but when I want to view records i get problems.

  2. #2
    Join Date
    May 2003
    Location
    Stuck in Michigan
    Posts
    4
    How are you viewing the records? What problems are you getting?

  3. #3
    Join Date
    Jan 2007
    Posts
    2

    Reply

    I got it to view the records now so thanks for your help. But I would like help in creating command boxes. I could get it to go to next record or previous, but I have problems getting it to add a new record in the form. Another problem is when go to next record it stops and give me an error. I would like it to go to the first record. I know you would have to go into the event procedure but I don't know the code.

    Thanks

Posting Permissions

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