Results 1 to 3 of 3
  1. #1
    Rendon115 is offline Novice
    Windows 10 Office 365
    Join Date
    Oct 2019
    Posts
    10

    Relatively simple relationship question


    I need a table that contains multiple choices that I can modify when needed. This table will be the list of options for two other tables, but I do not know how to structure this properly. Im new to relationships and tables entirely, but what I want accomplished is in the picture below:
    Click image for larger version. 

Name:	MaybeImRetarded.jpg 
Views:	19 
Size:	57.9 KB 
ID:	41997
    For each "choice 1,2,3, etc" there are multiple "stuffs" they could be. The "stuffs" are the things I will be changing when needed. I feel like Im missing something very basic here, but I cant quite seem to grasp it.
    Thank you,

  2. #2
    ranman256's Avatar
    ranman256 is online now VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    you do not need a relation for this. Its not a true relation.
    but you can use them as a lookup table for the user to pick items to fill in.

  3. #3
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    I think you are looking at the tables wrong.

    As you have drawn the tables, they are in DESIGN view. Each column is one RECORD. If you switched the center table to datasheet view, you would see 4 FIELDS of 1 record. "Stuff 1" is the FIELD NAME, not data. Not knowing anything else about the field,
    "Stuff 1" could contain "Chevy" or $4,000.00 or "1313 Mocking Bird Lane" or 15124581 or "Jane" or .....

    You COULD NOT link 3 FIELDS in one table to one field in a second table , NOR would you link 1 FIELD in one table/record to 3 FIELDs in one record in a second table.


    Click image for larger version. 

Name:	Relationship1.png 
Views:	12 
Size:	63.3 KB 
ID:	41998
    Maybe adding better names for the fields will help.
    Here you can see a one-to-many relationship between the right hand table and the middle table. One name can have many addresses.


    Remember that Design View looks different than Datasheet View. Don't confuse Field Names with Data.


    Instead of something made up, do you have specific tables and field names that are causing confusion?

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

Similar Threads

  1. Replies: 10
    Last Post: 03-15-2020, 01:46 AM
  2. About simple relationship and good practice
    By jaryszek in forum Database Design
    Replies: 6
    Last Post: 03-16-2018, 03:33 AM
  3. Simple Database Relationship Questions
    By dbmiller5 in forum Database Design
    Replies: 4
    Last Post: 07-18-2016, 12:20 PM
  4. Replies: 1
    Last Post: 06-13-2016, 03:05 PM
  5. Establishing a simple relationship?
    By Harry2 in forum Access
    Replies: 7
    Last Post: 06-16-2014, 02:41 PM

Tags for this Thread

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