Results 1 to 5 of 5
  1. #1
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568

    3 tables how to create relationships

    Hi Guys,

    i have 3 tables Click image for larger version. 

Name:	model.JPG 
Views:	20 
Size:	28.1 KB 
ID:	33026



    And know 1 Topology can have multiple ServerSizeInfo and Versions.

    So Topology1 can have ServerSizeInfo1, ServerSizeInfo2, ServerSizeInfo3 and so on.
    But Topology1 can have also Version1, Version2, Version3 and so on.

    So here it would be simple to create 1 to many relationship from Topology table to Versions table.
    But it is not possible to create second 1 to many ralationship (or it is not efficient?) between Topologies and ServerSizeInfo table.

    How can i solve this?

    Best,
    Jacek

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,521
    these may not need a relation.
    if you have a 4th table with equipment, then all 3 would join to that.

  3. #3
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    I agree with ranman. It seems there is a junction table in your set up (or possibly should be) to show which combination of values from these 3 tables applies.

  4. #4
    keviny04 is offline Competent Performer
    Windows 7 64bit Access 2016
    Join Date
    Apr 2015
    Posts
    128
    Quote Originally Posted by jaryszek View Post
    Hi Guys,

    i have 3 tables Click image for larger version. 

Name:	model.JPG 
Views:	20 
Size:	28.1 KB 
ID:	33026

    And know 1 Topology can have multiple ServerSizeInfo and Versions.

    So Topology1 can have ServerSizeInfo1, ServerSizeInfo2, ServerSizeInfo3 and so on.
    But Topology1 can have also Version1, Version2, Version3 and so on.

    So here it would be simple to create 1 to many relationship from Topology table to Versions table.
    But it is not possible to create second 1 to many ralationship (or it is not efficient?) between Topologies and ServerSizeInfo table.

    How can i solve this?

    Best,
    Jacek
    Is server size a "subset" of topology? If so, you need to put ServerSizeInfoID into your topology table. Same for VersionID. Your topology table will look like:

    Topology_ID
    Topology_name
    ServerSizeInfoID
    VersionID

    Then you can create the relationships. These will be many-to-one, not one-to-many. E.g. the topology table can have duplicate ServerSizeInfoIDs, but the server size info must have unique ServerSizeInfoIDs.

  5. #5
    jaryszek is offline Expert
    Windows 7 32bit Access 2010 32bit
    Join Date
    Aug 2016
    Posts
    568
    Hi Guys,

    thank you ! Junction table is very good idea.

    keviny04
    love also your idea.

    I will think about this.

    Best Wishes,
    Jacek

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

Similar Threads

  1. Can't create relationships (Driving me nuts!!)
    By zlloyd1 in forum Database Design
    Replies: 2
    Last Post: 08-12-2012, 08:49 PM
  2. How to create multiple table relationships
    By robi212 in forum Access
    Replies: 1
    Last Post: 03-30-2012, 07:59 AM
  3. Create Relationships
    By snowboarder234 in forum Access
    Replies: 4
    Last Post: 03-20-2012, 04:27 PM
  4. Replies: 5
    Last Post: 09-17-2011, 12:44 PM
  5. Replies: 3
    Last Post: 06-07-2011, 05:05 PM

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