I just use the Table Multiselect field type.
But when creating a document and select the multiselect value, when saving got error warning saying the value selected already exists. While in the document, the value is not selected, in other document it is selected.
How can I make the multiselect field select the values independetly to other documents?
I have 1 doctype (doc-A) with a multiselect field.
The multiselect field refers to a child table (doc-B).
The value in doctype-B are from a master table (doc-C)
I believe this arrangement is as directed by the documentation.
In a new doc-A I select the multiselect field and choose the values (populated from doc-C), for example: “abc”. And saving it. No issue here.
Then I create another new doc-A and fill in the multiselect field the value: “abc”, “def”.
When saving, there is a popup saying: Duplicate Name - multiselect “abc” already exists".
So the new doc-A can only be saved with “def” (I have to delete “abc”).
The next new doc-A then can’t use “abc” and “def” anymore.
I check the property of the multiselect field and see that it is Unique. Even when I uncheck this, when saving the doctype it goes back to checked.
In documentation it is written that this multiselect can only be selected once. I thought this happen only within the same document (this is correct).
But it happens that the “selected only once” also across documents (I can’t use a value if it is already selected in other document)
Just came to my attention that I set the auto-naming of doc-B and doc-C with the a field (this would automatically set the Unique property).
So I delete it and try to save again.
This time I get different warning: