<?xml version="1.0" encoding="UTF-8" ?>
<?xml-stylesheet type="text/xsl" href="https://www.infopathdev.com:443/utility/FeedStylesheets/rss.xsl" media="screen"?><rss version="2.0" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:slash="http://purl.org/rss/1.0/modules/slash/" xmlns:wfw="http://wellformedweb.org/CommentAPI/"><channel><title>General</title><link>https://www.infopathdev.com:443/forums/41.aspx</link><description>If 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.</description><dc:language>en</dc:language><generator>CommunityServer 2007 SP3 (Build: 31118.962)</generator><item><title>Re: validated a data field against a list.</title><link>https://www.infopathdev.com:443/forums/thread/92657.aspx</link><pubDate>Sun, 01 Sep 2013 22:47:36 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:92657</guid><dc:creator>Patrick Halstead</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/92657.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&amp;PostID=92657</wfw:commentRss><description>&lt;p&gt;You could write some code in your InfoPath form to do a filtered Access DB query by sending it a parameter.&lt;/p&gt;</description></item><item><title>validated a data field against a list.</title><link>https://www.infopathdev.com:443/forums/thread/92518.aspx</link><pubDate>Mon, 26 Aug 2013 16:39:30 GMT</pubDate><guid isPermaLink="false">033a2e2d-04e2-4a9d-be01-a4634161eefd:92518</guid><dc:creator>dimmthewitted</dc:creator><slash:comments>0</slash:comments><comments>https://www.infopathdev.com:443/forums/thread/92518.aspx</comments><wfw:commentRss>https://www.infopathdev.com:443/forums/commentrss.aspx?SectionID=41&amp;PostID=92518</wfw:commentRss><description>Hello, I am fairly new to Infopath development but I have been learning a lot lately. 

What I have is form for the input of a product.  There is a brand, a product, and a container drop down that are referenced from an Access Database table.

I have a field that is the concatenation of these three fields to query for a SKU product number.

I can send this data up and then reload with a query of the info I am submitting, but what I am trying to do is compare that concatenation against a table to see if it is a real product before I submit it.


I think what I am trying to do is input a parameter to a query, which I don&amp;#39;t think I can do with Access, I think I need SQL or a Sharepoint web services (which right now is not an option).


Maybe there is a web to have a static list in the form that I can compare the datafield to, for the condition of a rule?


Any help would be greatly appreciated, we are a small business and I wear a lot of hats.</description></item></channel></rss>