Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2007
    Posts
    6

    Help on Tables/relationships?

    I have a scenario and from it I have designed a database:





    Basically, it is a Student who chooses a Work, and many Fruits.

    1. tblWork and tblFruit consist of a list of works and fruits respectively.
    2. For now, Grade from tblWork is a combo box which consists only of the values 'Junior' or 'Senior'.

    After several attempts, I have achieved the tables & relationships above but they might be wrong. The scenario does not require the use of forms at all, just the database tables. Anyway my problem is that:

    To be a able to choose an 'Apricot', or 'Blackberry', the student should have a 'Senior' Grade.

    Any help on this please?, I am really stuck on this. Should some validation rules be implemented? or maybe some new tables/relationships created? I have tried all these but I really cannot move on.

  2. #2
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922
    It sure looks like a homework project to me.

  3. #3
    RuralGuy's Avatar
    RuralGuy is offline Administrator
    Windows 10 Access 2013 32bit
    Join Date
    Mar 2007
    Location
    8300' in the Colorado Rocky Mountains
    Posts
    12,922

  4. #4
    Join Date
    Oct 2007
    Posts
    6
    It is a quite big scenario where many endless possibilities exist. In fact, I posted just a part of my work (3 tables), I already hav 10-11 tables while my friends got 8-16 tables, it all depend the way you design it and to which extent.

    I never really got problems with MS Access till now, however it seems I was stuck somewhere. From what I understood: All the design should normally remain at the database tables level, so forms are not concerned since I am in fact designing a database system only.

    Everything would have been easy with Forms for me, but I think I must remain on the database tables level. so really any help ? redesigning tables? maybe separating 'Apricot', or 'Blackberry' as a separate entity/table?

    Thx, I am currently checking your links.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access - car rental relationships
    By ipwn in forum Access
    Replies: 0
    Last Post: 03-09-2009, 07:18 AM
  2. Relationships btw tables
    By metaDM in forum Queries
    Replies: 0
    Last Post: 03-05-2009, 12:15 PM
  3. Appending Records to tables with relationships
    By RubberStamp in forum Import/Export Data
    Replies: 0
    Last Post: 12-14-2008, 06:52 AM
  4. Training Database - Relationships
    By simmurray in forum Database Design
    Replies: 0
    Last Post: 01-12-2007, 03:39 AM
  5. I need help on relationships for tables.
    By justin.w in forum Access
    Replies: 0
    Last Post: 10-16-2006, 10:57 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums