SQL Database Integration

Re: Unique Values in Dropdown

gazzmate — Fri, 07 Apr 2006 14:36:23 GMT

whats the correct syntax for doing this in a access db table

Re: Unique Values in Dropdown

Greg Collins — Thu, 29 Dec 2005 16:16:47 GMT

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

Re: Unique Values in Dropdown

Patrick Halstead — Thu, 29 Dec 2005 06:21:29 GMT

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

Re: Unique Values in Dropdown

vt_asparagus — Fri, 23 Dec 2005 14:35:32 GMT

If the data is in a SQL DB, if you are using a select statement, why not do a select distinct?

Unique Values in Dropdown

oakridge — Tue, 20 Dec 2005 21:13:23 GMT

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.