AnsweredAssumed Answered

Showing relashinship

Question asked by HenryRobinson on Oct 7, 2017
Latest reply on Oct 7, 2017 by philmodjunk

For some reason relationships jumble in my mind so sorry in advance if this question lacks celerity.

 

I have a table named creatures that like it sounds lists creatures anything from a Bear to a Rabbit. What I would like to be able to do is take say the Bear and pick out other creatures that the Bear can eat for example the rabbit.

I made another table called Prey and setup a relationship that I pasted below. (Really cool I can paste in screenshot that easy by the way)

This worked I can now select a creatures out of Creatures | All and using a script set the UUIDs in prey.

What I am not able to do it show what ones are selected already. For example if I have the rabbit and deer selected but not wolf. I would like to be able to use conditional formatting to change the selected to green.

I was thinking this might work but no luck.

Creatures::Identifier | UUID = Prey::Identifier | UUID | Creature

and

Creatures | All::Identifier | UUID = Prey::Identifier | UUID | Prey

Outcomes