Cascading Dorp Down List in Repeating Table (Using Filters) - InfoPath Dev
in

InfoPath Dev

Cascading Dorp Down List in Repeating Table (Using Filters)

Last post 07-05-2011 11:43 AM by Jimmy. 5 replies.
Page 1 of 1 (6 items)
Sort Posts: Previous Next

  • 07-04-2011 09:35 AM

    Cascading Dorp Down List in Repeating Table (Using Filters)

    Reply Contact
    Hello! Thank you in advance for your time! I have created a cascading drop down list that links a type of bin to the size options available for it. I have assembled this using a filter (based on an Access table) as described on the Microsoft Office website (http://office.microsoft.com/en-us/infopath-help/create-a-cascading-list-box-HA001117713.aspx).  The only issue is that because I have a repeating section every time I open a new section the old options are available. For example: 
    Container Type Sizes Available
    Bag 1 M3
    BB 0.25 M3
      0.50 M3
      0.75 M3
     If I were to select Bag in my first option – only the 1 M3 would appear as an option (this is correct).  If I were to open another section (or even go back and change my option) to BB All the BB options would appear along with the Bag sizing option (1M3) which is not correct.   I need help on how to fix this. 

    Thanks again for your help!  I really appreciate it!

     

    Melissa 

     

  • 07-04-2011 10:02 AM In reply to

    Re: Cascading Dorp Down List in Repeating Table (Using Filters)

    Mark as Answer
    Reply Contact

    You should put a rule on the ContainerType field to always reset Size to blank.  A dropdown will show the bound field's current value in addition to the valid options if the current value is not in the available options.

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software

  • 07-04-2011 10:23 AM In reply to

    Re: Cascading Dorp Down List in Repeating Table (Using Filters)

    Mark as Answer
    Reply Contact

    Thank you for your quick resonse!  Sorry if this is a stupid question but how do I create that rule?

     

    Thanks,

     

    Melissa

  • 07-04-2011 10:58 AM In reply to

    Re: Cascading Dorp Down List in Repeating Table (Using Filters)

    Mark as Answer
    Reply Contact

    What version of InfoPath are you using?

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software

  • 07-04-2011 11:33 AM In reply to

    Re: Cascading Dorp Down List in Repeating Table (Using Filters)

    Mark as Answer
    Reply Contact
    It is 2007

  • 07-05-2011 11:43 AM In reply to

    Re: Cascading Dorp Down List in Repeating Table (Using Filters)

    Mark as Answer
    Reply Contact

    If you click a field in the data source taskpane, there should be an option to edit its rules.  Do this for the field bound to the first dropdown, and add a rule whose action is to set the field bound to the second dropdown to blank.  This rule will execute whenever the first field's value changes.

    Jimmy Rishe / Software Developer / Microsoft MVP
    Qdabra Software
Page 1 of 1 (6 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.