Fixed & variable field in Access Form

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • codakhan
    New Member
    • Feb 2014
    • 1

    Fixed & variable field in Access Form

    I have table studentfile. In this three field - Student name, subject name & marks in the subject. Each student has at most 9 different subjects. now i want to design a form so that, a label for student name & 9 label for subject name & 9 label for subject marks. but i could not design properly. could you help me please.
  • NeoPa
    Recognized Expert Moderator MVP
    • Oct 2006
    • 32663

    #2
    Main form for Student table.
    Separate table for Subjects.
    Yet another table for Student/Subjects (Don't use "/" in the name though).

    Your main form should have a subform to show the Student/Subjects.

    Comment

    Working...