AnsweredAssumed Answered

Pick and choose relationship?

Question asked by ChrisJohnston on Sep 18, 2013
Latest reply on Oct 8, 2013 by ChrisJohnston

Title

Pick and choose relationship?

Post

     If someone wants a system of information and the data that supports could this model work? I was trying to understand the possibility of a many to many relationship where the recipient of the data could be one of three members. In my illustration there are three possible tables the join needs to send data to. The reason I want the join to send info to different tables is because on some information I do not have Subtopics, or maybe I don’t have Topics, but some I do have both. To make that more clear:

     Information1
         •Topic1
         •Topic2
             *Subtopic1
         •Topic3
     Information2
         •Topic1
         •Topic2
     Information3
     Information4
         •Topic1
             *Subtopic1
      

     I need what the Entry (table) distributes (being Documents, Media, and Links) to go directly to the needed area. I have learned about the way that a database can reach across related tables to retrieve what it wants. So my thinking is that just because It wants (in one instance a particular relationship) that it could pick and choose the relationship based on need. Am I thinking of this in proper way? Are there better ways to do this?

pick%26chooserel.png

Outcomes