Forum Discussion

jcbutts's avatar
jcbutts
Icon for Helper I rankHelper I
5 years ago

Stuck on many-many relationship

Hi,   I normally try to find an example that matches my issue, but I need to get specific on this one.    I have two primary tables, "capstone" and "zordn(2)".  Both of them have multiples of the...
Need Help
jcbutts's avatar
jcbutts
Icon for Helper I rankHelper I
5 years ago

Update:  I've paired down the zordn(3) table to only have one column of data:  PO number.  I can get the model to show visuals using that PO number and some of the information from both tables simultaneousl (like "rank" from each table).  But as soon as I try to add other columns I get the greyed out visual and an error saying it couldn't detect the relationship.

 

Not sure why it can find the relationship for some columns but not others?

jcbutts's avatar
jcbutts
Icon for Helper I rankHelper I
5 years ago

Another update:  I can now get the data to show up by making one of the relationships to zordn(3) bidirectional.  While that will now allow me to see columns like "appt day/time" in my visual, if I take the "rank" columns out of my visual it says it can no longer detect the relationship.

 

I guess it's not the end of the world, but I'm really confused as to why removing a column from a visual table would cause it to break.