InfoPath Dev

I have one secondary data connection (a sharepoint list) that is feeding two separate dropdown lists (customer & generator) The selection in the first dropdown (customer) is supposed to filter the options in the second dropdown (generator) I reviewed the cascading blog by Greg but I can't seem to get it to work. Here is what I tried.

 not(. = ../preceding-sibling::dfs:ProfileData[@COMPNO = current()/my:Form_info/my:Company/my:COMPNO]/@GENNO)

 If anyone has any ideas on what I am doing wrong, I would greatly appreciate it. Thanks!

 Figured it out, I had the right filter but I also needed the first filter. Item is closed.

Hi shaun,

Try to put the dfs prefix before the 2 attributes of secondary data source.

not(. = ../preceding-sibling::dfs:ProfileData[@COMPNO = current()/my:Form_info/my:Company/my:COMPNO]/@GENNO)

 try this one.

not(.= ../preceding-sibling::dfs:ProfileData[@dfs:COMPNO = current()/my:Form_info/my:Company/my:COMPNO]/@dfs:GENNO)

Hope this will help you if the prefix is not there in the secondary data source then remove the dfs before the ProfileData and try this one

not(.= ../preceding-sibling::ProfileData[@COMPNO = current()/my:Form_info/my:Company/my:COMPNO]/@GENNO)