Unique Values in Dropdown - InfoPath Dev
in

InfoPath Dev

Use our Google Custom Search for best site search results.

Unique Values in Dropdown

Last post 04-07-2006 07:36 AM by gazzmate. 4 replies.
Page 1 of 1 (5 items)
Sort Posts: Previous Next
  • 12-20-2005 01:13 PM

    Unique Values in Dropdown

    I have read all of the articles on creating a unique list in a dropdown that is using values from a secondary data source this forum.

    I have a form with cascading dropdowns. These are working great! However I have repeating values in the first box.

    I am retrieving data from a SQL database to populate the dropdown. The name of the secondary data table is SW-VERSIONS. The name of the field is MACHINE.

    Here is the syntax that I enter when creating a filter with an expression as outlined in Greg Collins article Create a Cascading List form a Flat Data Source.

    not(.=../preceding-sibling::SW-VERSIONS/@MACHINE)

    I have also used
    not(.=../preceding::SW-VERSIONS/@MACHINE)

    Neither one of these work. Any help is appreciated.

  • 12-23-2005 06:35 AM In reply to

    Re: Unique Values in Dropdown

    If the data is in a SQL DB, if you are using a select statement, why not do a select distinct?
    Jason
    http://www.k2distillery.com/
  • 12-28-2005 10:21 PM In reply to

    Re: Unique Values in Dropdown

    Hi Oakridge and welcome,
    Very well articulated e-mail post. Not sure why the preceding-sibling isn't working. Some issue with secondary DOM perhaps? You might try with main just for fun. Greg might know. I'll forward to him.

    Patrick Halstead [InfoPath MVP]
    InfoPathDev
    Patrick Halstead
    Project Manager at Qdabra
  • 12-29-2005 08:16 AM In reply to

    Re: Unique Values in Dropdown

    It could be the structure of your schema. 1) What does your schema look like. 2) What node are you binding the drop-down list to? 3) In what order are the filters placed for this control?

    Greg Collins [InfoPath MVP]
    InfoPath Dev
  • 04-07-2006 07:36 AM In reply to

    • gazzmate
    • Not Ranked
    • Joined on 04-07-2006
    • Australia
    • Posts 1

    Re: Unique Values in Dropdown

    whats the correct syntax for doing this in a access db table
Page 1 of 1 (5 items)
Copyright © 2003-2019 Qdabra Software. All rights reserved.
View our Terms of Use.