Action- 'Select in Field' to be Dynamic and Recursive

[dmohanty]

Hi All,

I am having a data set like this below. I need to Create Action on a Button using 'Select Field'.

ID	Country	Group	Stuff
100	USA	Footwear	Boots,Sandals,Bellies,Canvas
200	CAN	Cereals	Rice,Wheat,Maize

Requirement:

1. The user will choose a value from the List Box: ID, let say value 100.
2. Then the corresponding value from Group = 'Footwear' will be used as 'Select in Field' and the values 'Boots,Sandals,Bellies,Canvas' will be used as 'Search String' in the Action of the Button.
3. Similarly when ID = 200 is selected the Action changes to Select in Field  = Cereals and the Search String = Rice,Wheat,Maize.

Can the Select in Fields be made dynamic like above scenario? Please help and guide!

[sushil353]

hi,

If you have 1 to 1 relation then you can use MaxString(stuff) to get the values from other field based on your selection

[svenkita]

create a drill down group and have the fields Group and Stuff

create a list box

attaching the sample

hope this helps

[dmohanty]

Hi Venkita,

Thank you for the help.

How can I use the Possible Values in the Stuff list box to be used as a Search String in Action of a Button?

Any suggestions?

[rwunderlich]

Are "Cereals" and "Footwear" field names, or field values?

-Rob