I have created a one to many bidirectional look up. However when i use the many side to set up associations to a specific entry... they can on exist on one entry... when i set them to another entry as well it removes them from the first entry.
in my example I am setting up a template that associates an engine to multiple cars. I also want to be able to say a more powerful engine could work with the same cars and that should be ok... however the database doesnt let me do this.
Ie...
engine X should be able to be used on cars A,B
engine Y should be able to be used on cars A,B
however right now... if try to do that it does this...
engine X should be able to be used on cars
(field cleared)
engine Y should be able to be used on cars A,B
I am wondering if I had clicked the No Duplicate Entries option, and then later unclicked it... the option was still saved in the bidirectional set up?
anyway... I am so close to having this work brilliantly but i have run into this problem and it is causing some headaches.
looking at the bidirectional examples in Zoho's help... they show it being used to choose hobbies for a person. It certainly seems multiple people should be able to share the same hobbies... hence it seems i should be able to do what i am proposing above.
thanks.
Dell