Filtering drop-downlist on web compatibility form - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Filtering drop-downlist on web compatibility form

Last post 01-14-2009 03:13 AM by cmpsfc. 3 replies.
Page 1 of 1 (4 items)
Sort Posts: Previous Next
  • 01-13-2009 05:38 AM

    • cmpsfc
    • Not Ranked
    • Joined on 01-13-2009
    • Posts 4

    Filtering drop-downlist on web compatibility form

    Hey everyone.

    I'm creating a new form that have a few fields wich is filled by external datasource, in this case SQLServer 2k5. The problem is, i need to filter a drop-down box list from another drop-down list box selected value and i have no idea how to do that, since i can't create any filter in datasource properties of this dropdown 'cause "filter is not compatibility with web form..."

     My database is something like that:

    dbState

    id - Name

    1 -  São Paulo

    2 - Rio de Janeiro

     and dbCity

    id - Name - idState(foreing key)

    1 - Guarulhos - 1

    2 - Santo Andre - 1

    3 - São Paulo - 1

    4 - Rio de Janeiro - 2

    5 - Angra dos Reis - 2

    ....

     

    Is there any way to select a State and automatically City's dropdown filter the citys of selected state?

     (sorry, if my english is not good enough... i'm just learning yet and i'm giving my best shot!  =D)

     

    Thx anyway! 

    cya!

     

    Filipe de Campos Cavalcante

    IW Developer!

  • 01-13-2009 07:41 AM In reply to

    • Anuma
    • Top 25 Contributor
      Female
    • Joined on 07-20-2005
    • India
    • Posts 525

    Re: Filtering drop-downlist on web compatibility form

  • 01-13-2009 10:48 AM In reply to

    • cmpsfc
    • Not Ranked
    • Joined on 01-13-2009
    • Posts 4

    Re: Filtering drop-downlist on web compatibility form

     Hi Anuma,

    Thx for your reply.

    Unfortunally i got another issue. Now i can't create an project to my form, as pdf says..

    When i clickt at "programming >> changed event" i got this error: " Infopath cannot add the event handler".

     

    Any ideas?

    thx again!

  • 01-14-2009 03:13 AM In reply to

    • cmpsfc
    • Not Ranked
    • Joined on 01-13-2009
    • Posts 4

    Re: Filtering drop-downlist on web compatibility form

     Hummm.... i don't know what i did, but it's working now...

     Well... i wrote that code to test and when i publish form template by Administration Central the status keep "installing"....

    it's taking too long to install... since yesterday!

     

    any ideas?

     

    thx! =D

Page 1 of 1 (4 items)
Copyright © 2003-2018 Qdabra Software. All rights reserved.
View our Terms of Use.