Tweet
Seems a bit strange this question, but let me explain:
I have artwork in one entity and another entity called exhibition. So I organize an exhibition by a linked filed, where I can link the artwork for that exhibition.
There could be the situation, that in parallel a second exhibition has to be organized at the same time. So obviously all the artwork, which is in exhibition one cannot be exhibited in exhibition two, as normally artwork is unique (besides multiples and editions of print e.g.).
Is it somehow possible to block a related record, pereferably by condition or ifThen formula, if it - in this case - is a record of an artwork, that has been added to an exhibition before?
The relationship in the moment is 1:n or n:n.
I have artwork in one entity and another entity called exhibition. So I organize an exhibition by a linked filed, where I can link the artwork for that exhibition.
There could be the situation, that in parallel a second exhibition has to be organized at the same time. So obviously all the artwork, which is in exhibition one cannot be exhibited in exhibition two, as normally artwork is unique (besides multiples and editions of print e.g.).
Is it somehow possible to block a related record, pereferably by condition or ifThen formula, if it - in this case - is a record of an artwork, that has been added to an exhibition before?
The relationship in the moment is 1:n or n:n.