Using columns of similar data like degree type

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • rneeraj
    New Member
    • Apr 2010
    • 1

    Using columns of similar data like degree type

    I am preparing an Employee database and would like to add more than one education details column in a form for each employee. Eg: A person must be holding a masters degree. I would like to add details of his masters as well as bachelors.How do i do so. Thank You
  • RuralGuy
    Recognized Expert Contributor
    • Oct 2006
    • 375

    #2
    It sounds to me like the education details should be in another table with the EmployeeID as a ForeignKey and a separate record for each degree.

    Comment

    • missinglinq
      Recognized Expert Specialist
      • Nov 2006
      • 3533

      #3
      As Allan has indicted, when you have a piece of data, like college degrees, and no way to pre-determine how many degrees you're dealing with, the thing to do is to add another table, in just the way he described.

      Welcome to Bytes!

      Linq ;0)>

      Comment

      Working...