<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.infopathdev.com:443/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>General</title><link>https://www.infopathdev.com:443/forums/41.aspx</link><description>If you're not sure where to ask your question, ask it here. If necessary, our moderators will make sure it gets classified in the correct board.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Multiple selection list box to drive the remaining questions asked in questionnaire</title><link>https://www.infopathdev.com:443/forums/thread/105430.aspx</link><pubDate>Mon, 08 Feb 2016 23:58:46 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:105430</guid><dc:creator>kyle.williams</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/105430.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&amp;PostID=105430</wfw:commentRss><description>Hi All, I&amp;#39;m facing a tough one, that I may just need an outside perspective on. 

1) Users answer a multiple selection box, where they can answer up to 5 or 6 programs.
2) After these 5 or 6 are selected there are another 20 or so questions that get asked and there are overlaps of questions asked between these 5 or 6 programs

These questions are all driven from a custom list, if a question falls into a particular program or programs it would be asked and the options that are associated with that question are also presented in an appropriate drop-down or multi-select box.

So, how can I ensure that I get the questions options presented in the drop-down and question text presented as well. 

I&amp;#39;ve found use for the &amp;quot;All of occurrences&amp;quot; and doing the lookup, but really struggling with situations where multiple programs are chosen.

Some supporting data to help illustrate:

Program Table

ID Name
1 Prog 1
2 Prog 2


Question Table

Question Number |  Text   |   Program
1 | Question 1 |  1
2 | Question 2 |  1
3 | Question 3 |  1
1 | Question 1 |  2
2 | Question 2 |  2
3 | Question 3 |  2


Question Options Table

Question | Value | Option Text | Program
1  |  1  |  Yes  |  1
1  |  2  |  No   |  1
2  |  1  |  Yes  |  1
2  |  2  |  No   |  1
3  |  1  |  Yes  |  1
3  |  2  |  No   |  1
1  |  1  |  Yes  |  2
1  |  2  |  No   |  2
2  |  1  |  Yes  |  2
2  |  2  |  No   |  2
3  |  1  |  Yes  |  2
3  |  2  |  No   |  2

Value is what get&amp;#39;s entered in as the response to a question and option text is what is presented in the drop-down.

1) Pick program(s)
2) Show question 1,2,3 based on the selections, but leave it open so that if questions 2 is deactivated for program 2, it can do this dynamically. IE the list drives what is /isn&amp;#39;t asked of each respondent.

Thanks all for the help! Just need someone to get me over the hump with a clever idea.</description></item></channel></rss>