display contents of table box based on selections made in list box

[#1]

Hi,

     I would like to display contents of table box based on selections made in listbox, example I would like to display contents of a table box if I select two division ids (ex.division id =1 AND division id=2) at a time, I tried to use the Calculation condition for this but it didn't work, it worked for OR(division id=1 OR division id=2) though. Please help me out I am a beginner.

Thanks in advance! !

[#2]

I recommend you to use straight table as it got more features. If the fields are associated it should work. I think its not the problem of calculation condition. Please check your linking relationship first. Or may be you can upload the qvw for the community members to have a try on it!

[susovan]

Hi Madhuri,

Can you provide any screen shot of your requirement?

[sunny_talwar · Accepted solution]

May be try this as your condition:

SubStringCount('|' & GetFieldSelections([division id], 100, '|') & '|'), '|', '|1|') = 1 and

SubStringCount('|' & GetFieldSelections([division id], 100, '|') & '|'), '|', '|2|') = 1

Made few mistakes above, the correct expression would be this:

SubStringCount('|' & GetFieldSelections(Division_ID, '|', 100) & '|', '|1|') = 1 and

SubStringCount('|' & GetFieldSelections(Division_ID, '|', 100) & '|', '|2|') = 1

[marjan_it]

can you make a sample?!

[sunny_talwar]

Are you asking me or the OP to provide a sample?

[susovan]

Hi madhuri,

Is it your requirement?

[marjan_it]

actually asked you. bcz I have a ques like this and I want to see in a sample

[sunny_talwar]

Used Susovan's sample and made some modification. Check it out

[marjan_it]

Thanks so much