Pick and choose relationship?
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:
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?