Values in a select box

[Cupcake]

Is there a way or is it even possible to have a list of values in a select box type of variable and only show some of the values based on a the answer to a previous question?

So I have a question called category - which is a select box type that has different values (Envelope, Envelope with no window),

        Then I have a list of item descriptions (that the customer also wants as a select box type) but they only want certain item descriptions to selectable in the list based on the category.

Thanks,

Karen

[Cupcake]

Thanks Fred and Abhinay.

        I spoke with the customer and yes they want that functionality but an extra layer has been added.

They want to be able to use the "Add a Row" functionality which is accomplished using a catalog table variable. So I am going to have to create the variables directly inside of the catalog table variable; as well as, the choices. I've done this part before but the tricky part is going to be hide / show of certain values based on the category.

I sincerely thank you and I will keep this information for future projects that may require me to use your solutions.

Happy Holidays.

Karen

[Abhinay Erra]

Of course it is. But in your case Lookup select box is the best approach instead of select box. And now you can import all the choices in to a table and use reference qualifier on the lookup select box based on the Envelopes and envelope non-window. Let me know if you need any help.

[Cupcake]

So Abhinay I am thinking about this again.

Because I have to use a catalog table variable to include the add a row functionality, I can still use the lookup select box so I can have all the choices in a table, but I guess where I am getting stuck is if ALL of the descriptions are in the table, but some of the descriptions are dependent on another choice field called category. Can I still accomplish that this way.

[Abhinay Erra]

If it is a lookup select box, yes, you can filter to show only certain descriptions based on the category. That can be done using a reference qualifier. But I am not familiar with the table variable.

[Raviteja K]

Hi abhinay

When I give lookup select box for getting unique values of field in a table, form is taking time to load nearly 2 mins. I there any alternate solution for this.