Is there a limit on the number of values for a reference qualifier

[Cupcake]

I created a table that has a list of item descriptions, in which I only want certain descriptions to be displayed based on the category. I submitted a previous question and it was suggested to use reference qualifiers. So I did, now the dilema is one of the categories has about 19 descriptions that I want to be visible if that category is selected. I had no issue setting up the reference qualifier but after the 4th value, all of the other values are removed.

See screenshots below:

        FYI: I tried different options such as Item Desciption CONTAINs and then kept selecting OR,

                      I tried Item Description IS and the exact name of the description, followed by selecting OR,

                      I tried Item Description is one of and pasting all the values in the list.

No matter what I used, it is only allowing 4 values.

Am I doing something wrong?

Thanks,

Karen

[Chris M3]

What I would do in cases like this is add a field on your reference table, that indicates whether it can be referenced in this way.   It can be a boolean field, or it could be a drop-down type field if there are multiple ways that something can be used.

For example, In the models table, we have a custom boolean field indicating whether it's the 'purchase model', i.e., the model as it's listed from our suppliers.   Then on the asset, we have a purchase model field, that can only be models with that flag.

This way, you are not hard-coding a bunch of values.   You can set an ACL up to limit who can make those changes.

[Abhinay Erra]

Use advanced reference qualifier for this . Let me know if you need any help in scripting.

[Cupcake]

Yes I will definitely need assistance. Any assistance that you can provide would be most appreciative.

Thank you.

Karen

[Abhinay Erra]

what is the field name of item description on the stock room item descriptions table? And is this reference qualifier dependent on any other variable?

[Cupcake]

Thank you Abhinay.

So my table only has the Item Description field. May I ask a question, should I update the table to include a field called Category, and list the category that applies for each item description. Will it be easier that way.

It is dependent on what the Category is.