InfoPath Dev

Basically I want a condition that will not allow a rule to run if a table row(s) contains both values of the drop-down list boxes. 

Although I have been playing around with InfoPath for a few years I have not dealt with creating secondary data connections using SharePoint or Access. My form currently uses an xml file as a secondary data source which is included in the template.  I am dealing with asset records from Peregrine Asset Center and will be shortly migrating ...

just wanted to check in and see if you had any suggestions for this.  Cheers Josh

The best solution for this I have found is muhimbi Software to automate your needs for infopath to PDF. Please tell them I referred you to their product. I am working on getting credit for another one of their products. I have been very happy with their products,  and highly recommend them. Let them know that Tom Berchenbriter Referred you.

Sometimes when I'm struggling with conditional formatting, I use some expression boxes to see if my XPath is returning what I'd expect it to. In a section bound to the same group that @SkillLevel is in, put a calculated value control (expression box in IP 2007) and put the first half of your condition in there:@SkillLevel[../../@Title = ...

Ok...I see how to do that. Thanks so much! I've deleted the forms and now I'll have to keep watch to see if i have any more problems. Thanks so much for your help! I've been battling this for months!  

I know you can use the "any occurence of []"  but what if I want to filter on a row based on two values? I have 2 drop downs list boxes that contain data that may exist in the table.  I want to make sure that the table does not have a row who's 2 fields do not match the drop downs. 

Thanks for the reply. However i don’t use SharePoint as you could read in the first post. So i just send it out to some external users, and i dont want them to steal and make changes to my work basically. I know its an xml file so its easy to edit and just turn off whatever i put in the file and turning off stuff and so. But ...

Hi IT_Girl, Have you tried using filtering in InfoPath to do this?  You should be able to do this using filtering, perhaps take a look at this article on the Office web site: http://office.microsoft.com/en-us/infopath-help/filter-the-data-that-is-displayed-in-a-control-HA010024281.aspx Hope that helps Ted

Hi Subhash, Take a look at this blog on our site that talks about the best way to open InfoPath forms: http://www.infopathdev.com/blogs/shiraz/archive/2007/08/16/best-way-to-launch-forms-from-web-pages.aspx Hope that helps Ted