Results 1 to 2 of 2
  1. #1
    minnetonka is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2011
    Posts
    2

    This Relationship is killing me


    It feels like I've been trying to solve a Rubik's cube in the dark. I've got most pieces in place but have hit a stopping point...

    The relationship?

    1 - 1st form where the user enters two or more cars (car table).
    2 - 2nd form has options (ie. everything from full size spare, to seat material, to color) available in several categories where they can select values (0,1,2,3) from a look-up table on how important each of these options are.
    3 - 3rd form - Crash! For each option I now want the user to set a rating for each option comparing each car against each other. Example: For an option of seat material the user should be able to rate one car as a "3" for one car and a "1" for the other...and be able to do this for all options.

    I've tried different types of relationships and queries but just can't seem to get it. I'm pretty sure its a Relationship, but... Ideas?

    Thanks.

  2. #2
    minnetonka is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2011
    Posts
    2

    Add some more detail

    I have 5 tables:

    Table 1 - Cars
    ID Field - Autonumber
    Car Field - Text

    Usage: Can Add a car name in the Car field - e.g. Mom's car and Dad's car

    Table 2 - Car Option
    ID Field - Autonumber
    Option Field - Text
    Category Field - Lookup to Category Table
    Weight - Lookup to Number Table

    Usage: Can look at each Option and assign a Weight (0, 1, 2, 3) to an Option according to the importance that Option has to the user - e.g. Option of "Trailor Hitch" has importance/Weight of "3" for the user compared "Leather Seats" has a importance/Weight of "1" as lesser importance

    Table 3 - Categories
    ID Field - AutoNumber
    Category Field - Text

    Usage: Is a lookup table for assigning categories to Options

    Table 4 - Numbers
    ID Field - AutoNumber
    Number - Number

    Table 5 Ratings - Not sure if I need this or need to roll this into one of the other tables - read on....
    ID Field - Autonumber
    Rating - Lookup to Number Table

    Usage: Is a lookup table containing values of 0, 1, 2, 3

    So here is where I get stumped.

    I'm trying to have the user -

    1 - User enter a car - "Mom's" and "Dad's" - This works
    2 - User then Weights each Option from "3" (Very Important) to "0" (No importance) - This works
    3 - User then Rates each Option against the Cars - e.g. Option of "Trailer Hitch" for Mom's car is "0" (no hitch!) and for Dad's is "3" (has a hitch) - can't figure out how to do this!!

    Can't figure out what type of relationship, or how to craft the query, or where exactly the Ratings are written. Any ideas welcome.

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

Similar Threads

  1. many-to-one relationship
    By reverze in forum Access
    Replies: 7
    Last Post: 07-14-2010, 10:03 AM
  2. One to one relationship
    By ManvinderKaur in forum Database Design
    Replies: 2
    Last Post: 06-28-2010, 05:37 PM
  3. one to many relationship?
    By cowboy in forum Access
    Replies: 3
    Last Post: 06-16-2010, 02:37 PM
  4. Killing open applications using VBA
    By zippy483 in forum Programming
    Replies: 4
    Last Post: 03-03-2010, 10:04 PM
  5. MAY TO MANY RELATIONSHIP
    By fadone in forum Database Design
    Replies: 2
    Last Post: 12-20-2005, 09:03 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