https://www.infopathdev.com:443/forums/41.aspxIf 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.enCommunityServer 2007 SP3 (Build: 31118.962)https://www.infopathdev.com:443/forums/thread/5283.aspxWed, 18 Jan 2006 18:22:24 GMT033a2e2d-04e2-4a9d-be01-a4634161eefd:5283Anonymous0https://www.infopathdev.com:443/forums/thread/5283.aspxhttps://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&PostID=5283Hi:<br /><br />I have a form connected to a SQL datasource. It uses a master/detail control. I'm using a combination of textboxes and dropdown boxes in the detail section, with conditional formatting to mimic a combobox--if the field is blank, the dropdown shows. My dropdown is connected to a secondary datasource, which is a table in the same SQL database. Here is a simplified example of my data structure:<br />Main Connection<br />Group -- SystemConfigs<br /> Field -- ID<br /> Field -- SorterFamily<br /> Group -- LightingSystems<br /> Field -- ID<br /> Field -- LightingSystems<br /> Field -- SystemID<br /><br />SystemID in the LightingSystems group relates to ID in the SystemConfigs group.<br />Secondary Connection (used for dropdown)<br />Group -- LightingSystems<br /> Field -- ID<br /> Field -- LightingSystems<br /> Field -- SystemID<br /> Group -- SystemConfigs<br /> Field -- ID<br /> Field -- SorterFamily<br />For my dropdown, I need the LightingSystems displayed to be unique values that are associated with the correct SorterFamily, which is why I added SystemConfigs as an additional table in my secondary data connection.<br /><br />If I filter using the following XPath, I get only values associated with the correct SorterFamily:<br />The expression ../d:SystemConfigs/@SorterFamily = current()/../@SorterFamily<br />If I use this next XPath, I get only unique values:<br />The expression not(. = preceding::d:LightingSystems[/descendant-or-self::node()/@SorterFamily = current()/../@SorterFamily]/@LightingSystems)<br />If I use both. . . I lose values that show in two different SorterFamily attributes. For example, if for SorterFamilyA I have HID, Laser and UV lighting systems, they will all show in my dropdown. But if for SorterFamilyB I also have a UV lighting system, it will not show.<br /><br />Any ideas why each of these filters works correctly on its own but not in combination?<br /><br />Thanks--Hilary