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
Creatures | All::Identifier | UUID = Prey::Identifier | UUID | Prey