I don't follow your logic here. The sample appears to be only a single table, but you are referring to multiple tables. Can you clarify?
This sample is from a full data set that I have vastly simplified. I am hoping that I might be able to connect the set as I have said in the original post. However the data came from a large connection of several tables within the same database. The green is the original connection that is breaking because in certain scenarios as shown the value is actually equal to the teal instead of the green. Which is why this super simple table is the same up until the nulls. And as you can see the nulls come into play when the Dest Type is 1 instead of 3.
So again to reiterate: Can you connect one Table to two different Tables based off of a value from the first table to flag which table to connect from one ID to one of two IDS (For the two corresponding Tables)?
Here is a picture of how the Tables are set up. GSiteID is in Table B. DestinationID and Dest Type is in Table A. And WSiteID (WSite) is in Table C.
So could you connect A to B through DestinationID -> GSite ID when Dest Type is 3 and A to C when Dest Type is 1.
Hopefully that will help clear up the logic, but I get it is a very abstracted concept.