I was wondering if it were possible to have the choices that appear in a dialog list field, be based upon what is selected in a dialog list field before it.In other words, I would like the first dialog list to contain the Names of all states. Then let’s say New York is selected for the first dialog field. I would like to appear in the second dialog list, the addresses of the different offices in NY state. Is this possible?
Thank you!
Subject: RE: Dialog list choices based of dialog choice before it
Yes it is possible.what u can do is create a hidden computed field which fetches all the values based on the choice u made on the 1st dialog list. Now use Formula for choices in the field u want to fetch these values and give the hidden filed’s name there.
Subject: RE: Dialog list choices based of dialog choice before it
nice 1,thank you for your post. I am a little bit fuzzy on understanding what I need to do. When you say “creat a hidden field which fetches all the values based on the choice u made on the 1st dialog”, which values amI fetching and from where am I fetching them?
Thanks!
Subject: RE: Dialog list choices based of dialog choice before it
Hiyou can make use of @DbLookup in the hidden field which fetches values based on the choice u make in the 1st dialog list form the view. Make this hidden field text and allow multiple values, now to fetch these values in the second dialog box, in the control tab of that field(second dialog), select “Use Formula for choices” and give the hidden field’s name in the box below. this will work i have used this in one of my application as well.
In case of any more queries please feel free to ask…and tell me if it works…