Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2003
    Location
    Dayton
    Posts
    3

    Question Unanswered: Mutli-Valued Attributes Access 2002??

    Im making a DB that has a bunch of classes (the kind with students in them). Im going to have multiple kids in each class and Im trying to think of a decent way to design the DB to hold all the info. A multi-valued attribute would work nicely, but I dont think Access 2002 can do it. Am I going to have to have another table with each student and the class they're signed into? Any help is appreciated. Thanks in advance.

  2. #2
    Join Date
    Apr 2002
    Posts
    139
    Yes, design it with a second table for the Kids.
    Assuming a Kidd will only belong to one Class, and a Class may contain more kids (just like I remember school :-)

    Table Class will have a ClassID which is autonumber.

    Table Kids will have a KiddId which is autonumber, and also a second field called ClassID which is set to long integer.

    Set the relation between ClassID in Class-table and ClassID in Kids-table. Access will propose a one-to-many.
    Study whether to set referential integrity on or off.

    hth

  3. #3
    Join Date
    Feb 2003
    Location
    Dayton
    Posts
    3
    Ya,

    That's the way I have it set up now. I just wanted to see if there was an easy way to do it. Thanks a lot for the reply!

Posting Permissions

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